Power BI

In SQL there are different types of JOIN, available for different purposes. This article shows the equivalent syntaxes supported in DAX and it was updated i

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

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.

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

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 […]

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.

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

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…

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…

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

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…

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

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…

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

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

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…

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.

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

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

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

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…

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