Posted by
Sam Lowrie
on 30 September 2024
Updating a measure definition is easy but what happens when you have 200 to update? This blog guides you through using the Dax Query View to achieve this.
Posted by
Sam Lowrie
on 09 September 2024
When using more complex measures there may be a need for each to be formatted differently. This blog shows you how to use the dynamic formatting measure feature.
Posted by
Andrew Gould
on 23 February 2024
The February 2024 update to Power BI has an interesting new preview feature: visual calculations. These allow you to create DAX calculations within individual visuals in a report. This blog shows why that's useful!
Posted by
Andy Brown
on 02 October 2023
You have to tweak Power BI a bit, but you can now generate quick measures using Microsoft's AI Copilot tool (which will be coming to all 365 applications over the coming months). In this blog we see if it works, and if your job is in danger ...
Posted by
Andy Brown
on 30 June 2021
DAX contains a number of incredibly useful hidden short-cut keys, allowing you to move lines, comment code and much more!
Posted by
Andy Brown
on 22 March 2021
How can you highlight the row in a table corresponding to the slicer value you've chosen? With a disconnected slicer and a clever measure!
Posted by
Andy Brown
on 22 February 2021
Be careful of referencing measures in calculations when you have duplicate rows in a table! This blog explains why you might want to hang on to that unused primary key column.
Posted by
Andy Brown
on 22 January 2021
How can you show each aggregate value in a group as a percentage of the highest aggregate value? This blog shows two ways to use DAX measures to solve this deceptively difficult problem.
Posted by
Andy Brown
on 14 January 2021
Did you know that you can write an EVALUATE DAX query in software like DAX Studio and then run it from within Power BI to create a new table? You do now!
Posted by
Andy Brown
on 02 December 2020
Inspired by a question from a course, in this blog Andy Brown builds up a measure to show cumulative totals for a calendar matrix, dotting his DAX i's and crossing his t's!
Posted by
Andy Brown
on 24 October 2020
Following a question from a recent DAX course, here are 3 recommended YouTube tutorial channels to help you learn to master DAX.
Posted by
Andy Brown
on 13 February 2020
Simple Talk provide excellent how-to guides on any aspect of Microsoft software. We are proud to have contributed a series of articles explaining how to create DAX calculated columns and measures within Power BI.
Posted by
Sam Lowrie
on 08 November 2019
This blogs shows a clever way in which you can use a slicer to choose which values to compare in a measure.
Posted by
Sam Lowrie
on 28 October 2019
The RANKX function does what the name implies - it ranks values based on a calculation. However, the VALUE argument often causes confusion; this blog explains what it does!
Posted by
Sam Lowrie
on 22 February 2019
Context transition happens when a DAX function creates filter context within row context, or vice versa. This blog explains what context transition is, and shows which DAX functions make use of it.
Posted by
Sam Lowrie
on 29 January 2019
Row context (along with its sibling, filter context) is one of the most important concepts in DAX. This blog explains what row context is, and how to use it!
Posted by
Sam Lowrie
on 25 January 2019
Understanding filter context is the key to understanding how to create measures in DAX. This blog aims to explain this vital subject as succinctly as possible!
Posted by
Andy Brown
on 06 December 2018
Following a question from a Power BI course, this blog shows how you can get a page to show the top N customers by sales value, where N is a number controlled by a slicer.
Posted by
Sam Lowrie
on 05 November 2018
Given your current stock levels and forecast sales, it should be possible to report on future stock depletion in Power BI. This two-part blog shows you how to just that!
Posted by
Sam Lowrie
on 30 July 2018
Learn to use DAX variables, and understand how they can be used to break up code. Not true debugging, but better than nothing!