Forum Discussion

SJ25's avatar
SJ25
Resolver I
4 years ago

If statement not working after publishing

I have a simple calculated column as mentioned below: Status_1  IF(Table[MaxDate] = BLANK(), "Uncf", IF(Today() > Table[MaxDate], "PD", "Not PD"))   I use this to create a simple table showing ...
Need Help
Shishir22's avatar
Shishir22
Solution Sage
4 years ago

Hello SJ25, 

 

This might happen because Power BI server may be situated in other then your zone. Can you please try creating a measure as today() just to check what date is coming.

 

I would suggest to use UTC time and convert it into your timezone and then try to check.

 

Please accept it as a solution if it solves your issue. Kudos are also accepted!

 

Thanks,

Shishir