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!

2 Easy Steps to Loop with Power Query! List.Accumulate()

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,630 views

Power BI's "Automagical" Column From Example Feature (for any web page!)

Brent Jones

Apr 26, 2019

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

95 views

Improbably Unhelpful Power Query / M Custom Functions that You Might Not Never Use.

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

136 views

Power BI: Top 10 Companies in GA - Plus Nested Queries

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

Get Worksheet Data In the Current Workbook With Power Query

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

28,384 views

Power BI: Creating a Function with Python

Brent Jones

Aug 22, 2018

Power BI: Creating a Function with Python

Read about how to create a Python function in Power Query!

800 views

Power BI: Building a Digital Nomad Dashboard

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!

215 views