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!
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey SaraFtg ,

 

can you share the file? It would be a lot easier to take a look at the file itself.

 

Best regards

Denis

SaraFtg's avatar
SaraFtg
Frequent Visitor
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!