Brent JonesFeb 11Using a Custom Function Within List.Generate()Looping with the M language is not easy. What if you want to loop a custom function and break out of the loop based on the functions return
Brent JonesJan 25Performance of Dynamic M Query ParametersInitially I thought this could improve the report latency/speed for reports using direct query mode. After all, Microsoft themselves say...
Brent JonesOct 6, 2022Calculating Business Days and Hours Between Two Dates (DAX)Power BI DAX has a function called "NETWORKDAYS()". However it does not calculate hours. If you need to calculate hours, you can use this...