Brent JonesMay 18, 2023Convert Column Names to Lowercase (or Uppercase) in Power QueryHow to convert column header names to lowercase, uppercase, or proper case in Power Query?
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.