The Antares Alien

Power BI | DAX

Blarg! Here, I write about Power BI stuff in a fun and unique way. I also occasionally write about video game development. Thanks for checking out my blog!

Using a Custom Function Within List.Generate()

Brent Jones

Feb 11, 2023

Using 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

1,888 views

Performance of Dynamic M Query Parameters

Brent Jones

Jan 25, 2023

Performance of Dynamic M Query Parameters

Initially I thought this could improve the report latency/speed for reports using direct query mode. After all, Microsoft themselves say...

280 views

Making Power Query More Dynamic: The Magic of Lists

Brent Jones

Jan 23, 2022

Making Power Query More Dynamic: The Magic of Lists

Lists can be used to make Power Query more dynamic, like dynamically renaming or reordering columns.

7,309 views