top of page
The Antares Alien
Power BI
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
Dec 21, 2024
How to use ADDCOLUMNS and SUMX in a Measure
The performance gained essentially doubles the speed of the "normal" version of the code!
54 views
Brent Jones
Sep 3, 2024
Optimized Calculation for the Minimum Distance Between Two GPS Coordinates using DAX
How to optimize minimum distance calculation between two sets of GPS coordinates?
26 views
Brent Jones
Aug 1, 2024
The Definitive Guide to DAX - Book Review
The Definitive Guide to DAX is truly a definitive guide to DAX - a title well named.
51 views
Brent Jones
Jul 15, 2024
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
107 views
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
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!
138 views
Brent Jones
Oct 30, 2023
Calculation Groups in Power BI Desktop
Calculation groups can now be authored directly in Power BI desktop!
414 views
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
Brent Jones
Mar 18, 2023
What is the Difference Between FILTER and CALCULATETABLE?
What is the Difference Between FILTER() and CALCULATETABLE()?
1,559 views
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,482 views
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.
268 views
bottom of page