Power BI

DAX Studio 2.16 has two new preview features: Show Debug Commas and Show XMLA Commands. With Show Debug Commas you enable a button to move commas from the e

This article describes how blank values considered in a DAX conditional expression can affect its query plan and how to apply possible optimizations to impr

Learn how to change the direction of a relationship within a Power BI measure using DAX expression with CrossFilter function

This tutorial will discuss about materialization for data caches in DAX Studio. This post will show how it affects your calculation while generating results with your query. You’ll learn which materialization is better in order to maximize DAX’s performance.There are two ideas of materialization: Ear

In this tutorial, you’ll learn about what data caches do in a DAX calculation. You’ll understand how they work with the formula and storage engines to provide answers to your queries.Download Free Resources HereWhat Are Data Caches?The storage engine interacts with the formula engine in the form of a

This blog post is following on my previous posts using community tools to improve your data model. Previously we used Tabular Editor: here and here. Now let’s define what RI (referential integrity) …

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