DAX

Hi , Based on my test, you can refer to below steps: 1.I have entered some sample data to test for your problems. Table1 is the data I entered below in the picture. Table2 covered the data of [bin]. 2.Create a calculated column to calculate your frequency in 'Table2'. Create a table ...

While working with Dates in DAX, you may have come across an interesting behavior when working with the DATEADD() function. If have used this function in SQL, you have a good idea of how the functi…

In this Power BI tutorial, learn how to tell the difference between calculated columns and measures and discuss use cases for each.

By answering to a student question I realized we often used a wrong calculation of customers age in DAX, and the simple solution is to borrow the same techn

Conditional Formatting Using Text In Power BI Desktop Hello P3 Nation! Today’s “post” is actually going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’…

Learn how to use Slicers to control Groups of visuals on a report page. This is a handy technique when you might want to perform comparisons between Items.

very recently when we were working on a BI project, we needed to create a Power BI report to visualize certain detail level information. Therefore we used Matrix visual for that. When we were devel…

This article describes how to optimize DAX expressions that have mutually exclusive calculations, which might cause slow query performance. We discussed in

The prices of individual investment securities can vary widely and thus a common reporting practice is to standardize or index these values to a baseline value such as 100. For example, Apple’…

There are several undocumented DAX formula bar keyboard shortcuts in Power BI Desktop. For instance, you can comment or uncomment portions of your code, go to a specific line of code, and do other thi…

The other day I discovered something new (at least to me) while writing the DAX for a measure in Power BI Desktop: when you insert a new line in your DAX expression using SHIFT-ENTER it also auto-i…

Thanks to 's insightful guidance and examples in his fantastic new book, Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence, I finally "get" the GENERATE function and how it can be used to elegantly solve a problem that has vexed me since almost the very first Power BI ...

Recently I went about upgrading the DAX formula reference guide provided to all those connected with Enterprise DNA. At the same time I wanted to distribute it more widely as I know there is a huge re…

This is my newest book that teaches all Power BI users how to supercharge the value they get from this fantastic new tool. Learning to write DAX...

I received a question about how to implement the equivalent of a DISTINCTCOUNTX function in DAX. Well, such a function doesn’t exist in DAX, but imagi

This article describes a very common optimization pattern using variables to optimize conditional expressions in DAX. In a previous article, we already show

What is data science? At its heart, it’s the ability to extract insight from data. Successful practitioners know that understanding basic statistics is the first step toward mastering this skill. Read…

Organizing and keeping track of your DAX measures in a tabular model can be a challenging task, especially when working with larger Analysis Services projects. Visual Studio does not give you much hel…

Let’s start off today’s post with a pop quiz: Once you’ve answered, click here to see the poll results, and then scroll down to see the correct answer. … ... … The correct answer is C. DATEADD is a table function which takes a table of dates as input, shifts those dates by a given number of days, and returns

This post shows how a dynamic member called Other can be used for Data Visualizations in Power BI in addition to the common requirement of the visualization of the TOP N or BOTTOM N members. A solution is used that utilizes a combination of data modeling and DAX.

In this video, Marco Russo, from SQL BI, joins Patrick to look at how you can debug DAX using variables in Power BI. Marco helps to break down a DAX measure and show how you can see the results as you build it up to find where the problem is. SQL BI DAX Formatter DAX […]

If you have a fiscal year starting in March, you can have a problem using the time intelligence functions in DAX. For example, by using February 28, the fis

One of the relatively new functions for Analysis Services Tabular, Power Pivot and Power BI is TREATAS. In this tip, we’ll introduce you to the syntax and concepts of the function and show some uses cases where this function can be useful.

Disconnected Slicers With DAX Variables & SELECTEDVALUES Hello P3 Nation! Today’s “post” is actually going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written word, and especially to screenshots. So this post will be in moving picture