Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.