Power BI

It is often the case in Power BI you need to filter your data to include or exclude rows where there are blanks. Be careful though, because you might get unexpected results. Consider this table:

Today I am sharing another of those videos where I show you how I have built out my COVID report for Australia http://xbi.com.au/ca   The live report is running a few weeks ahead of my blog videos, so that is why you will see features in the live report that I [...]Read More »

ALLEXCEPT is a handy DAX function to retrieve all the columns of a table except for some. When used as a CALCULATE modifier, its behavior is less intuitive

Create a running total formula in DAX that starts from arbitrary dates instead of considering the complete history available.

Earlier this week I did a live stream event.  I put out a poll and asked people to tell me what topic they wanted me to talk about.  The options were Calculated Columns vs Measures Tips for Excel users moving to Power BI Using Variables in your DAX The overwhelming [...]Read More »

Variables can simplify your DAX code, help with debugging and help improve performance. To use variables in your DAX measure you need to declare a variable using the VAR keyword, give the variable a name, and then assign an expression to the variable. You can use multiple variables in a measure but when using variables […]

When you use a measure as a filter in a Power BI visual, the DAX code generated might show a different behavior whether the measure is part of the values sh

Video by: Reid Havens Learn how to display DAX expressions in the description tooltip - when hovering over the measure in the fields list. This can be applied to all measures easily and effortlessly using Tabular Editor . Related Content External Tool - Tabular Editor External Tool

From time to time, I stumble upon data that have a starting and an ending time. It could be opportunities in a CRM system, time between an email arrived in you mailbox until it was responded to or a …

This video shows how to create a like for like comparison in DAX comparing equivalent periods, and how to correctly implement a Boolean condition in a calcu

Learn how to fetch the latest status in a period through an HR Power BI design pattern showing the latest position to date.

Calculation Groups in Power BI can be amazing! Patrick shows you how you can create these common patterns with just one click using Tabular Editor. Blog: https://www.esbrina-ba.com/time-intelligence-the-smart-way/ Calculation Groups: https://docs.microsoft.com/analysis-services/tabular-models/calculation-groups?view=asallproducts-allversions Tabular Editor: https://tabulareditor.com

Looking at new ways of Expressing Date and Time Values in Power BI DAX in order to more quickly do analysis with Date and Time.

This article describes how to customize the drillthrough experience in Excel PivotTables connected to Power BI datasets or Analysis Services databases. When

Learn how to add a year-month combination into the Power BI report using DAX and sort it correctly using an example.

To understand how a filter can affect performance, first we need to understand what a filter is. A filter is a temporary table that is created on demand, held in memory, and then used as a reference for the function being filtered. The rows of the temporary filter table are all DISTINCT. This is because […]

Unfortunately, it does happen… You have just added a new calculation group/calculation item to your model and all of the sudden, some of the visuals on your report stop working. Usually, the main r…

Recently while working on a consulting project, I came across a very interesting problem. It was interesting enough, that I am passing it on to you.   Consider this Employee Data The data represents an employee role for each month, since the employee’s joining date. Each row means 1 employee assigned to a certain role [...]

Version 1.1 of the #exportreportobjects script has been released! With this version, the script will identify unused objects (measures/columns within your...

Sometimes you want to highlight the lowest value in a Power BI visual. First you need to find it! Then you can highlight it. What if you want to ANIMATE it? Patrick shows you how to do just that! ALLSELECTED() article: https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/

Enhance your performance testing and measure tuning skills by learning DAX as a query language.

It is possible to filter a matrix by a measure, but may lead to unexpected results. See one such case and a possible workaround with a calculation group.

In DAX, optimizations and data types do not always play nice and can leave you dealing with surprises. In this short article, we see an example of how mixin

Microsoft Hates Greg. Contribute to gdeckler/MicrosoftHatesGregsQuickMeasures development by creating an account on GitHub.

Microsoft Hates Greg's Quick Measures Image concept and credit: Rocket Deckler Introduction Today I am announcing the availability of a new External Tool for Power BI Desktop, "Microsoft Hates Greg's Quick Measures" or MSHGQM for short. This tool more than doubles the number of Quick Measures avail...

This is where you describe the app...

As an extension to my recent article on base conversions in DAX, I thought I’d show how these conversion calculations can be used to help you perform bitwise calculations in DAX. At present, there …

I recently came across a real head-scratcher of a question on Stack Overflow. This post is an expansion of the answer I gave there. The goal is to provide a useful model to understand filter context. This is foundational knowledge for any aspiring DAXter (DAXist?) and is required to understand CALCULATE properly.