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

Hm, when adding the MembertYear-column (also set to Don't summarize) to my visual the problem seems to be that -1 is set to 120 (resulting in that it's grouped as "50+"). So - question is why that is happening?

 

 

selimovd's avatar
selimovd
Most 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!