Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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