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!

What is the Difference Between FILTER and CALCULATETABLE?

Brent Jones

Mar 18, 2023

What is the Difference Between FILTER and CALCULATETABLE?

What is the Difference Between FILTER() and CALCULATETABLE()?

1,511 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,888 views

Calculating Business Days and Hours Between Two Dates (DAX)

Brent Jones

Oct 6, 2022

Calculating Business Days and Hours Between Two Dates (DAX)

Power BI DAX has a function called "NETWORKDAYS()". However it does not calculate hours. If you need to calculate hours, you can use this...

2,424 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?

21,317 views

Brent Jones

Oct 28, 2019

Displaying Unity's Game Build Log

If you ever want or need to display Unity's build report with graphs and charts, you can do that with Power BI. The set up takes a coupl

1,781 views

Exploring "Overtourism" with Power BI (Part 1)

Brent Jones

Jun 8, 2019

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

209 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

98 views

Want to Build Your Own Neural Network With Python?

Brent Jones

Dec 18, 2018

Want to Build Your Own Neural Network With Python?

Book review for "Make Your Own Neural Network" by Tariq Rashid. Excellent job of explaining the concepts in an easy-to-understand

42 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.

159 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,886 views

Power Query: Preventing "The column of the table wasn't found" error

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.

54,813 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,205 views