Timing M Query Execution In Power Query And Power BI (Revisited)

In M, the DateTime.LocalNow() function returns the current system date and time at the time the function is called – which means that you could call it multiple times in the same query and get different results. There’s also the DateTime.FixedLocalNow() function which also returns the system date and time; the difference between the two is, as the documentation says:

Bron : Chris Webb’s BI Blog
Lees meer…