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
How to Copy and Paste a Table in Power BI?
Use the TMDL view to easily copy and paste Power BI tables along with all of their properties!
Brent Jones
Feb 6
74 views
How to use ADDCOLUMNS and SUMX in a Measure
The performance gained essentially doubles the speed of the "normal" version of the code!
Brent Jones
Dec 21, 2024
104 views
How To Make a Mekko Chart in Power BI
This is how you can create a mekko chart in Power BI, without using third party visuals from the appsource.
Brent Jones
Sep 18, 2024
68 views
Optimized Calculation for the Minimum Distance Between Two GPS Coordinates using DAX
How to optimize minimum distance calculation between two sets of GPS coordinates?
Brent Jones
Sep 3, 2024
32 views
The Definitive Guide to DAX - Book Review
The Definitive Guide to DAX is truly a definitive guide to DAX - a title well named.
Brent Jones
Aug 1, 2024
71 views
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
Brent Jones
Jul 15, 2024
153 views
Performance Comparison of Power BI Visual Calculations
Visual Calculations propose an enticing performance benefit; one that can potentially improve loading speeds drastically.
Brent Jones
Apr 28, 2024
188 views
Measure, Dimension and Switch Parameters in Power BI. What's the Difference?
In Power BI, you can create three different types of parameters of what I call; Measure, Dimension and Switch parameters.
Brent Jones
Feb 10, 2024
1,570 views
Power BI: Optimizing Multiple Parameters for a DAX Measure
See how to write a DAX measure using multiple parameters in Power BI
Brent Jones
Dec 21, 2023
308 views
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
Brent Jones
Dec 17, 2023
84 views
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!
Brent Jones
Nov 19, 2023
178 views
Calculation Groups in Power BI Desktop
Calculation groups can now be authored directly in Power BI desktop!
Brent Jones
Oct 30, 2023
435 views
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?
Brent Jones
Aug 20, 2023
108 views
PBIP Files - A More Developer Oriented Approach for Working With Power BI Projects
We now have access to PBIP files. These are "Power BI Project" files that you can create via Save As -> PBIP
Brent Jones
Jul 13, 2023
409 views
A Beginner's Guide to Automating Power BI with the Layout File (Part 3)
In this article, we will discuss how to change the measure of a Power BI visual programmatically with Python.
Brent Jones
Jun 6, 2023
615 views
A Beginner's Guide to Automating Power BI with the Layout File (Part 2)
In this article, we will go over how to automate the visual position of a Power BI visual using the Layout file with Python.
Brent Jones
May 27, 2023
645 views
A Beginner's Guide to Automating Power BI with the Layout File (Part 1)
Want to automate Power BI visual elements with Python? This guide is for you.
Brent Jones
May 25, 2023
1,832 views
An Alternative to Calculation Groups in Power BI
How to create calculation groups in Power BI without Tabular Editor?
Brent Jones
Apr 8, 2023
1,070 views
What is the Difference Between FILTER and CALCULATETABLE?
What is the Difference Between FILTER() and CALCULATETABLE()?
Brent Jones
Mar 18, 2023
1,683 views
Performance of Dynamic M Query Parameters
Initially I thought this could improve the report latency/speed for reports using direct query mode. After all, Microsoft themselves say...
Brent Jones
Jan 25, 2023
312 views
bottom of page