DAX

The right title for this blog post should be “Guidelines for SQLBI content publishing”, but it would be too boring. And, at the time of writing, the mor

Calculated columns in composite models can have a big impact on performance

Learn how to use DAX Query View to get metadata from Power BI Semantic Models including as columns, tables and measures.

This article describes how to optimize time intelligence calculations with DirectQuery over SQL in Power BI by avoiding time intelligence DAX functions. NOT

This article describes the difference between the results of DATEADD and PARALLELPERIOD in DAX. These differences also impact many other time intelligence f

Native slicer does not allow to reverse the selection, but reversing the selection on a slicer is a possible workaround with limitations.

If you are trying to manage customer or employee engagement, but have no quantitative understanding of impressions, engagements, and conversions, then you have zero grasp of your reach. If basics a…

In this short post, we will explore how to create a DAX measure for Top N ranking with drill down. Purpose of this DAX Measure In many business scenarios, understanding the performance of products at different levels of a hierarchy (such as Category, SubCategory, and Product) is crucial. The ‘Top N Ranking with Drill Down’ measure in DAX allows users to dynamically rank products at each level of this hierarchy based on their sales performance. This dynamic capability means that...p class="read-more"a class="btn btn-default" href="https://datakuity.com/2024/01/23/dax-measure-top-n-ranking-with-drill-down/" Read Morespan class="screen-reader-text" Read More/span/a/p

Troubleshooting DAX performance is one of the most challenging, yet most rewarding tasks! Learn how to leverage DAX Studio external tool to quickly understand why your DAX query is slow!

This article describes how to join tables in DAX when there are no relationships in the data model. The data lineage plays an essential role in this scenari

This article describes the practical uses of NATURALLEFTOUTERJOIN and NATURALINNERJOIN in DAX. These functions are not commonly used in DAX because they do

DAX query view, released in public preview last month, in the December 2023 Power BI Desktop release has exciting updates including the new INFO DAX functions and improvements to the Update model CodeLens.

In November 2023 release we added a new fourth view in public preview to Power BI Desktop, the DAX query view! The DAX query view gives you the ability to write, edit, and see the results of Data Analysis Expressions or DAX queries on your semantic model. Finally, you can now take advantage of the existing DAX queries syntax while working with your semantic model without leaving Power BI Desktop.

Power BI table visuals with a visual-level filter applied may perform worse than expected, and applying the filter inside your measures may improve performance

Using variables with IF or SWITCH can affect performance

This article describes how to use the DAX time intelligence calculations applied to the latest period available in the data, also known as the “current”

Introduction

Master the art of creating and utilizing flags as measures with DAX in Power BI. Dive into insightful techniques and boost your data analytics skills.

In this blog, I will share 7 golden rules for writing DAX formulas that will help you create more sophisticated and effective calculations.

This article explains a typical pattern to optimize a SUMX iterator by reducing the number of callbacks in the expression. Pushing calculations down to the

Explore Power BI's new 'Visual Calculations'. Jay ter Heerdt unveils faster DAX calculations at Persian Power BI User Group. Watch now!

This article describes how to apply conditional formatting on measures picked from a slicer and implemented using two techniques: field parameters and calcu

If you’re monitoring activity in Power BI, for example using Log Analytics, you’ll know that you can capture the DAX queries generated by your published Power BI reports. How do you mak…

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.