Tag: Advanced DAX

A Power BI DAX Tutorial On Cumulative Comparisons

A Power BI DAX Tutorial On Cumulative Comparisons

In today’s Power BI DAX tutorial, I want to go over quite an interesting technique that uses DAX really effectively. I had to work on a scenario where we were running some analysis on our email campaigns. I wanted to know how many emails we receive on a day, compare it on a monthly basis,

Continue reading

Using Text Functions In Power BI – DAX Tutorial

Using Text Functions In Power BI – DAX Tutorial

In today’s tutorial, I’m going to show how you can use path functions and text functions in Power BI to extract certain words from a given text string. You may watch the full video of this tutorial at the bottom of this blog. In this example, we have two rows of data set and we

Continue reading

Power BI Matrix | How To Fix Matrix Totals In Power BI

Power BI Matrix | How To Fix Matrix Totals In Power BI

For this tutorial, I’m going to show you how to fix Power BI matrix totals, particularly fixing totals and subtotals if the measures you create don’t produce the right results originally. You may watch the full video of this tutorial at the bottom of this blog. There are two reasons why I wanted to address

Continue reading

Matrix Visual In Power BI: Controling Totals & Subtotals

Matrix Visual In Power BI: Controling Totals & Subtotals

Today, I’ll show how you can control totals and subtotals in your matrix visual in Power BI. You may watch the full video of this tutorial at the bottom of this blog. This is a problem posted by one of our members at the Enterprise DNA forum. The user wanted the columns to look like

Continue reading

DAX Measure Analysis: Breaking Down Long DAX Measures

DAX-Measure-Analysis--Breaking-Down-Long-DAX-Measures

In this tutorial, I’m going to show you some detailed DAX measure analysis on how I put together one of my favorite pages in the report I submitted for the 10th Power BI Challenge. The Rankings page uses a lot of challenging DAX measures. But with the help of one of our Enterprise DNA experts,

Continue reading