Forum Discussion

SJ25's avatar
SJ25
Icon for Resolver I rankResolver 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
SJ25's avatar
SJ25
Icon for Resolver I rankResolver I
4 years ago

I am using List.Max in power query to get the MaxDate, and I am thinking that's where it's going wrong when the report is published but I don't know what else to try. 

Edit: I tried to create another calculated column to get the max date, still no difference.