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

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

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

Published on May 13, 2018: In this video, we will learn about 1. The background of people who learn DAX and why they encounter difficulty 2. What concept tak...

Obviously T-SQL and DAX are two different query languages and it serves entirely different purposes.However, as a person who came from database development background , when I learn DAX initially, …

Hey guys!! You might have seen my previous post about adding working days. This is still part of the same problem, however, I've established a method that I need help writing the correct code for. Assuming my date table looks like this: (May 9th is a holiday for example purposes) Date Wo...