How to Display Multiple Rows in a Single Cell of a Matrix or a Table

How can I condense multiple rows into a single cell in a Matrix or a Table? https://youtu.be/bjCclP7aTCQ Obviously, it is easy to display all details like you see below: But what if for every product I just want to know what countries it is selling in and what channels are used? Like how it is … Continue reading How to Display Multiple Rows in a Single Cell of a Matrix or a Table

What to Do When Calculation Groups Break Your Measures (PowerBI Tutorial)

Unfortunately, it does happen… You have just added a new calculation group/calculation item to your model and all of the sudden, some of the visuals on your report stop working. Usually, the main reason behind is some sort of invalid DAX in your calculation group. However, sometimes this might happen even if on a surface … Continue reading What to Do When Calculation Groups Break Your Measures (PowerBI Tutorial)

Taking another look at ALL() and ALLSELECTED() Functions

I have a video that takes another look at All() and AllSelected() functions. I start by talking about the flow of filters in the model. The direction of the arrow in the relationship between Fact and Dimension matters. With this background, I talk about using All() and AllSelected() function on Dimension table and compare it … Continue reading Taking another look at ALL() and ALLSELECTED() Functions

How to Deploy Azure Data Factory (ADF) from Dev to QA using Devops

Just wanted to do a quick video to cover the process of deploying ADF artifacts from Development environment to higher environments like QA, etc. these are the basic steps to get it done (please watch the video for detailed instructions) https://youtu.be/7fsIwWheyDk Create a new project in Devops if there is no project set up alreadyMake … Continue reading How to Deploy Azure Data Factory (ADF) from Dev to QA using Devops

Incrementally Load New Files in Azure Data Factory by Looking Up Latest Modified Date in Destination Folder

This is a common business scenario, but it turns out that you have to do quite a bit of work in Azure Data factory to make it work. So the goal is to take a look at the destination folder, find the file with the latest modified date, and then use that date as the … Continue reading Incrementally Load New Files in Azure Data Factory by Looking Up Latest Modified Date in Destination Folder

Price Volume Mix (PVM) Calculation in Power BI with New and Discontinued Products (Power BI Dax Tutorial)

Price Volume Mix (PVM) calculation is one of the most popular topics on my blog and YouTube channel. Although, I have covered the DAX for the perfect PVM before, I have gotten a lot of requests to extend the PVM logic to include a separate bucket for discontinued products as well as new products. You … Continue reading Price Volume Mix (PVM) Calculation in Power BI with New and Discontinued Products (Power BI Dax Tutorial)