Forum Discussion

SaraFtg's avatar
SaraFtg
Frequent Visitor
5 years ago
Solved

Calculated column changes value in report

Hi,   First, English is not my mother tounge, so I hope I make myself understood :).   I'm quite new att Power BI and I'm struggeling with a calculated column and the outcoming result in my repor...
Need Help
  • SaraFtg's avatar
    SaraFtg
    5 years ago

    Hi selimovd,

     

    After some more digging I found that empty cells in date column in my Customer table returned 30/12/1899, so when I calculated MemberYear the result became 120 years.

     

    Instead of IF(ISBLANK(vContractMemberFrom),-1,... I tried IF(vContractMemberFrom = 0,-1,... and now it seems to work fine.

     
    Thanks for taking your time to respond to my issue!
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
5 years ago

Hi SaraFtg ,

 

After reviewing your question, it seems that it has been resolved. You can mark the correct response as the standard answer to help the other members find it more quickly.

 

If there is still confusion, you can describe your problem in detail and provide relevant data and information. I will answer you as soon as possible.


Best Regards,
Henry