Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a simple calculated column as mentioned below:
Hi @SJ25 ,
Power BI Service uses UTC time, please add or subtract the corresponding time difference in your formula and check again.
Best Regards,
Jay
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.
Hey Shishir, I tried that and the date is showing as 24/3 which is correct. I also checked to see if the date formate for MaxDate is dd/mm/yyyy. There are 5700 rows in Table and now the report is showing all of them under "Uncf" status and blank for the other two categories.
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