top of page

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

Brent Jones
Sep 23, 2019
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.
3,891 views


Brent Jones
Nov 24, 2018
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
138 views

Brent Jones
Nov 12, 2018
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.
70 views


Brent Jones
Oct 31, 2018
Power BI: Ultimate Solution to Parameters and Changing Data Sources
Changing a data source is done on the Power Query side of Power BI. This can be a bit of a hassle as you need to open up the Power Query edi
282 views

Brent Jones
Oct 12, 2018
Analyzing the "All Time Best" Video Games with Power BI
Are there any trends among top selling video games? I decided to tackle that question with some help from our good friend Power BI.
726 views

Brent Jones
Sep 21, 2018
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
29,299 views


Brent Jones
Aug 22, 2018
Power BI: Creating a Function with Python
Read about how to create a Python function in Power Query!
822 views


Brent Jones
Aug 20, 2018
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!
217 views

Brent Jones
Aug 16, 2018
Power BI: Using Python to Get Your Data
Find out how you can write Python code inside the Advanced query editor with Python.Execute()
2,351 views


Brent Jones
Aug 15, 2018
Data Management: Power BI Data Types with M or Report Design UI?
Having the correct data types in your Power BI model is essential for a fast performing dashboard. For the most part, Power BI does this...
10 views

Brent Jones
Aug 13, 2018
Power Query: Preventing "The column of the table wasn't found" error
Read about how to prevent errors resulting from column name changing.
55,154 views


Brent Jones
Aug 9, 2018
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
7,341 views
bottom of page