dax

How to modify the basket analysis measure to compute the Sales Amount of orders that have both products selected? This unplugged video show how we analyze t

dynamic labels and calculation group precedence seem unrelated, but need to go hand by hand. This article shows a technic to avoid the dangers.

In week 26 of Workout Wednesday for Power BI, I asked people to calculate the age of Nobel laureates at the time they received the award. I provided some logic, but I didn’t prescribe how to …

Learn how easy you can create a fully-fledged calendar table in Power BI using a DAX script just by copy and paste into your file.

Learn how to leverage the power of calculation groups to activate inactive relationships without creating multiple measures!

TREATAS: Treats the columns of the input table as columns from other tables. https://dax.guide/treatas/

Convert a “Top N and others” measure pattern into a calculation group that can be applied to any DAX measure in a Power BI model.

This article shows how to use calculation groups to define a default set of values for columns in your model. Different users can have different default val

Learn how to use calculation groups to define a default set of values for columns in your model. Different users can have different default values, and yet

Tags a measure expression specified in the call to SUMMARIZECOLUMNS function to be ignored when determining the non-blank rows.

Recently I was asked to provide an example of a custom Linear Regression Trendline in Power BI that can dynamically re-calculate for both different levels of a Date hierarchy along with different filter selections. After designing and creating the example, I thought it would be useful to share wit...

This week the Power BI team announced an awesome new feature. It's the ability to run DAX queries against your Power BI datasets via a REST API. Wow, wow, wow! Given that coding API's might not be something everyone has the ability to do, I thought I'd share how you can use Power Automate to run a DAX query, extract data & save it to a file. Here is a high level summary of the Flow I built: Obtain a Token to authenticate to the Power BI REST APIs Call the new Power BI API, passing a DAX query Pa

This article provides you with the technical knowledge to choose between using a Date or an Integer to create the relationship between your fact table and t

You’ve spent time creating Calculation Groups in Power BI only to find that they don’t work. What’s up with that? Patrick may be your only hope. Calculation Groups Documentation: https://docs.microsoft.com/analysis-services/tabular-models/calculation-groups

This video provides you with the technical knowledge to choose between using a Date or an Integer to create the relationship between your fact table and the

This article explains how the CONTAINS function works and what can be used as better alternatives in DAX in common use cases. The CONTAINS function in DAX h

Push datasets are an efficient and inexpensive way to implement real-time updates in Power BI reports and dashboards. They can provide better performance an

Here is how to calculate a moving average or sum in Power BI by using DAX. Sometimes moving average is called running or rolling average.

In this post we'll have a look at 3 complex cases where DAX proves to be a more efficient tool than Excel.

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