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!

Convert Column Names to Lowercase (or Uppercase) in Power Query

Brent Jones

May 18, 2023

Convert Column Names to Lowercase (or Uppercase) in Power Query

How to convert column header names to lowercase, uppercase, or proper case in Power Query?

2,193 views

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,821 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...

266 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,092 views

Power BI: How to Remove Duplicates and Keep Most Recent?

Brent Jones

Aug 7, 2021

Power BI: How to Remove Duplicates and Keep Most Recent?

How to remove duplicate records while ensuring that you keep the most recent item?

20,873 views

Calculating Business Days and Hours Between Two Dates (Power Query)

Brent Jones

Apr 17, 2021

Calculating Business Days and Hours Between Two Dates (Power Query)

Here is a Power Query custom function to calculate the number of hours. All you need to do is just copy and paste this code into a blank que

6,022 views