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

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

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

In this writing, I like to share what I have learned about OFFSET DAX function, that recently came out to the world, but not yet documented on https://learn.microsoft.com/en-us/dax/ as of today. When I face the situation to measure date-intelligence-related business requirement, I use SAMEPERIODLASTYEAR, DATESINPERIOD, DATEADD, and so many other time intelligence DAX functions, if a business is using normal & general calendar table. Or, I use FILTER, MIN, MAX, and some other DAX functions, if

Analyze, visualize, and report on your data using 92 new DAX functions when creating measures in Power Pivot.

I have been blogging about DAX since before Power BI was a product; I started back in 2014 and Power BI was first released as generally available in mid 2015.  Until about 2017, the only way you could build a commercially viable production reporting tool that used DAX was via [...]Read More »

RANKX is a simple function used to rank a value within a list of values. Its use is simple, but it can be a source of frustration for newbies. In this artic

Ways we can get to the total's row in Table or Matrix visual using HASONEVALUE & INSCOPE functions in Power BI

Writing Tabular Editor C# Scripts in Visual Studio has many benefits, on top of all Intellisense. This article walks through the configuration process.

One of the fundamental things missing from Power Bis visualisation capabilities is the ability to easily control data labels. Having to resort to hacks is not ideal but if good data visualisation i…

This blog post shows you how to use the DAX function EvaluateAndLog and how to use the DaxDebugOutput app with Power BI to view the results

Recently I had an interesting use case where I had to a compound calculation in Power BI. You can compound an interest rate for example, where you get a certain rate on your savings. Let's say 1% (which is at the time of writing ridiculously high, but bear with me). After 1 year, you get 1% interest

✨A new DAX function that is already available in the September release of #PowerBIDesktop, but was hidden in the last updates announced in September. ✨#OFFSET allows to make comparisons in context between two values, without writing extremely long and complex