top of page
The Antares Alien
Power BI
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!
Search
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?
Brent Jones
May 18, 2023
2,948 views
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
Brent Jones
Feb 11, 2023
2,007 views
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...
Brent Jones
Jan 25, 2023
312 views
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.
Brent Jones
Jan 23, 2022
7,677 views
Power BI: How to Remove Duplicates and Keep Most Recent?
How to remove duplicate records while ensuring that you keep the most recent item?
Brent Jones
Aug 7, 2021
22,241 views
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
Brent Jones
Apr 17, 2021
6,351 views
Power BI: How to Improve Refresh Speed
When working with Power BI, sometimes the refresh speed is excruciatingly slow.
Brent Jones
Jun 27, 2020
7,899 views
Power BI: Easily Find a Column Name with this Function
I was recently working on a project where there were over 28 thousand tables in the database.
Brent Jones
Jun 19, 2020
4,393 views
2 Easy Steps to Loop with Power Query! List.Accumulate()
Here's the situation: I have a list of values (text/string). I want to create one single concatenated string based on that list.
Brent Jones
Sep 23, 2019
4,004 views
Exploring "Overtourism" with Power BI (Part 1)
The alien walks us through a comparison of increases in tourism per country per year. Also go over some Power Query and DAX tips including A
Brent Jones
Jun 8, 2019
222 views
Power BI's "Automagical" Column From Example Feature (for any web page!)
Power BI has a somewhat hidden feature you may not have know existed - or maybe you knew about it but haven't given it a thought to try
Brent Jones
Apr 26, 2019
101 views
Power Query: Merged Tables, Aggregate and Non-Aggregate Values
Why Power Query doesn't give you the option to expand a merged table with both non-aggregate values AND aggregate values. Let's take
Brent Jones
Apr 8, 2019
4,471 views
Improbably Unhelpful Power Query / M Custom Functions that You Might Not Never Use.
This is a collection of Power Query / M functions that I've used in the past. I'm using this article as an open collection so that y
Brent Jones
Nov 24, 2018
142 views
Power BI: Top 10 Companies in GA - Plus Nested Queries
How do the top 10 companies in GA and their respective tax payment in 2018 line up? Plus, a look at nesting queries within queries.
Brent Jones
Nov 12, 2018
72 views
Get Worksheet Data In the Current Workbook With Power Query
You may already be familiar with the "Get Data" function in Excel. You can use this feature to send data from your worksheet to Po
Brent Jones
Sep 21, 2018
29,728 views
Power BI: Creating a Function with Python
Read about how to create a Python function in Power Query!
Brent Jones
Aug 22, 2018
833 views
Power BI: Building a Digital Nomad Dashboard
Read about how to make a Power BI dashboard to help you make a decision on the best countries to visit for a Digital Nomad Excursion!
Brent Jones
Aug 20, 2018
220 views
Power BI: Using Python to Get Your Data
Find out how you can write Python code inside the Advanced query editor with Python.Execute()
Brent Jones
Aug 16, 2018
2,376 views
Power Query: Preventing "The column of the table wasn't found" error
Read about how to prevent errors resulting from column name changing.
Brent Jones
Aug 13, 2018
55,447 views
How to Make a Cells Value a Power Query Parameter
Create easily editable parameters in Excel for Power Query to help your users. Use a named range in Excel for the query source. You can then
Brent Jones
Aug 9, 2018
7,495 views
bottom of page