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

What Kind of Video Game does the World Like to Buy?

Brent Jones

Dec 12, 2018

What Kind of Video Game does the World Like to Buy?

I recently got my hands on a great data set related to video games sales worldwide. Not only does it includes sales data, but also genre, Me

567 views

Power BI: Ultimate Guide to the Basics of Importing Data

Brent Jones

Oct 29, 2018

Power BI: Ultimate Guide to the Basics of Importing Data

To begin, click on the "Get Data" button on the Home tab of Power BI. This will bring up a new window with several options.

156 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

How to Make a Cells Value a Power Query Parameter

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