Brent JonesFeb 11, 2023Using 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 25, 2023Performance 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 JonesJan 23, 2022Making Power Query More Dynamic: The Magic of ListsLists can be used to make Power Query more dynamic, like dynamically renaming or reordering columns.