dax

SQLBI+ is our new subscription service to advanced content that support professional model authors who create semantic models for Power BI and Analysis Serv

Learn how to write DAX queries and how to manipulate tables in DAX measures and calculated columns. The DAX language is commonly used to create measures and

Horizontal fusion is a new optimization technique available in DAX to reduce the number of storage engine queries. In this article, we introduce this optimi

A step by step approach to write an optimized median measure in Dax

Why is DAX so hard to learn? It is an evergreen topic. DAX is difficult to learn because of its inherent complexity. DAX is presented as difficult to learn in ways that do not align with this complexity. The topic is evergreen because of demography among DAXists. This difficulty has spawned a movement, for lack of a better term, rebelling against CALCULATE and purporting to improve the experience of writing DAX by writing it worse. In this post, I will explore these topics and share some opinions on the same.

While participating in the 25 days of DAX Fridays! – Second edition challenge by Curbal, I was searching for a good way of finding the MAX value from multiple columns in a table.During my search I found a nice technique which requires very little DAX code but is perhaps not the most intuitive solution. In ... Read more

ABSTRACT 📝 Microsoft Power BI tool consistently provides new features and capabilities to transform the raw data into meaningful insights . Effective UI/UX solutions can be driven by various different functionalities such as, but not limited to: built-in visual-related formatting opti

A few weeks ago I wrote a post showing how you can use the new EvaluateAndLog DAX function to diagnose performance problems relating to the use of the Switch function. Did you know that calculation…

In October 2022, two new DAX functions appeared in the Power BI service: TOCSV and TOJSON. In this blog post, I'm showing a few use cases.

A common question is why Power BI totals are inaccurate because they do not display the sum of individual rows. In this article, we explain the reasons why

Bravo is a free tool created by SQLBI that helps you create a Power BI model with a simple user interface: Analyze Model, Format DAX, Manage Dates, and Expo

On the Microsoft Power BI Ideas Forum (https://ideas.powerbi.com/ideas/), there is a long-running re

3 simple but powerful Context Transition Examples . Covering- Calculate Sales for Best Selling Day of the Month, Calculate Best Selling Product's Sales Value & Calculate Best Selling Region's Sales Value

SELECTEDMEASURENAME: Returns the name of the measure that is currently being evaluated. https://dax.guide/selectedmeasurename/

This article covers Checks, User Interactions and Annotations in C# Scripts because they are basic building blocks of more complex scripts.

Problems with non-additive DAX calculations

A common question is why Power BI totals are inaccurate because they do not display the sum of individual rows. In this video, we explain the reasons why th

Learn about an up and coming external tool that makes it easy to identify and KILL unused measures and columns from a Power BI dataset (PBIX). Gregor Brunner will walk us through how to use this great tool, how it works, and more. Tune in to find out! Video by: Reid Havens

I had a requirement where I had a measure that I wanted to be filtered if it’s value was selected then it must show the value. As well as if nothing is selected on the slicer then I also want…

I got an interesting request this week, to improve the usability of the tabular model they wanted to filter the dimension table to only contain the rows that have data in the fact table. That way t…

This article describes how to create a table with a series of numbers in DAX by using the new GENERATESERIES function or through a workaround using CALENDAR

DAX Moving Averages measure controlled by slicer in Power BI, using what-if-parameters, GenerateSeries, and disconnected table.

Welcome back readers, to another chapter in the DAX Reanimator Series! The post I’ll be re-envisioning today is one I’m very excited about.

This article describes how DAX resolves column and measure names in DAX, providing best practices to avoid conflicting names. A fundamental rule you should

This article describes how to create a virtual relationship in DAX using the TREATAS function, which is more efficient than approaches based on INTERSECT or