Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have create a calculated column which computes the "Minutes Since last refresh" and used a card to diaply this column.
Here's the calculate column formula: Num Mins Since last Refresh = datediff(Tablename(datetime), now(), minute).
datetime is equal to DateTimeZone.ToLocal(DateTime.AddZone(DateTime.LocalNow(),-5)). So it gives me central time.
Now, when I do a "refresh now" in power bi web, the "Minutes Since Last Refresh" breaks and gives me the following error:
Hi @sieed,
You want to convert UTC to local time, right? If it is, you can use the DateTimeZone.SwitchZone function to transfer them to same time Zone. Or you can use DateTimeZone.LocalNow().
Reference links.
Convert utc to local time zone using Power Query
Display Last Refreshed Date in Power BI
Best Regards,
Angelia