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!

How to use ADDCOLUMNS and SUMX in a Measure

Brent Jones

4 days ago

How to use ADDCOLUMNS and SUMX in a Measure

The performance gained essentially doubles the speed of the "normal" version of the code!

1 view

Optimized Calculation for the Minimum Distance Between Two GPS Coordinates using DAX

Brent Jones

Sep 3

Optimized Calculation for the Minimum Distance Between Two GPS Coordinates using DAX

How to optimize minimum distance calculation between two sets of GPS coordinates?

20 views

The Definitive Guide to DAX - Book Review

Brent Jones

Aug 1

The Definitive Guide to DAX - Book Review

The Definitive Guide to DAX is truly a definitive guide to DAX - a title well named.

43 views

Brent Jones

Jul 15

How to Optimize DAX in Power BI

Optimizing your DAX code can be a challenging (even monumental) task. In this page, I've laid out five unique ways you can optimize your DAX

95 views

Power BI: Optimizing Multiple Parameters for a DAX Measure

Brent Jones

Dec 21, 2023

Power BI: Optimizing Multiple Parameters for a DAX Measure

See how to write a DAX measure using multiple parameters in Power BI

284 views

How to add a specific value to ALLSELECTED with DAX?

Brent Jones

Dec 17, 2023

How to add a specific value to ALLSELECTED with DAX?

This code is useful in scenarios where you want to include specific values in your calculations, irrespective of the user's selections, whil

74 views

Brent Jones

Nov 19, 2023

SQLBI Mastering DAX Workshop Review

I recently had the pleasure of attending SQLBI's 3 day Mastering DAX Workshop. Read on below for my thoughts!

130 views

Brent Jones

Oct 30, 2023

Calculation Groups in Power BI Desktop

Calculation groups can now be authored directly in Power BI desktop!

405 views

Do You Need Relationships For Power BI? A Look Into The Disconnected Model Paradigm.

Brent Jones

Aug 20, 2023

Do You Need Relationships For Power BI? A Look Into The Disconnected Model Paradigm.

This may be blasphemous to even ask, but... do you really need to join your tables in the first place?

104 views

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

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 show different date calculations on the same date axis.

Brent Jones

Nov 16, 2021

Power BI: How to show different date calculations on the same date axis.

Let's say you have a ticketing system and you want to show a count of tickets based on their created date and also on their completed date.

264 views