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

With the modern editors that have automatic code formatting features, each one has its own code formatting style. Usually there are a few “common rules”

Two of the most fundamental and ongoing questions in BI are 1) “What data and logic do we need in the data model?” and 2) “What data and logic do we currently have in the data mod…

Hi folks, After long time I feel to blog about this simple steps to add link to send email (Actually to open outlook to send email to specified email id) Click on enter Data Type here your message - A…

There are 3 types of evaluation contexts. Row Context Row context includes the values from all columns in a row and related rows. Row contexts doesn�t propagate through relationships (from the one sid…