DAX

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

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.

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

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

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

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 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

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

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...

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

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

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

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.

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

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

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.

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 …

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

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

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) …

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 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

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

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

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

I was helping someone recently with an issue. They wanted to allow end users (department managers in this case) to enter data in a table as simply as possible, and then use this data for reporting. The challenge often is, that the easiest way to enter data from a user’s [...]Read More »

Bottom N Analysis in Power BI

This article provides a complete explanation of the behavior of the ALLxxx functions in DAX. When used as filters in CALCULATE, ALLxxx functions might displ