Tag: Power BI DAX

DAX Calculation Groups To Avoid Unpivoting Columns

DAX Calculation Groups To Avoid Unpivoting Columns

In this tutorial, I’ll demonstrate how you can create 2 split percentages in a donut chart using DAX calculation groups while avoiding having to unpivot data in Power Query. You can watch the full video of this tutorial at the bottom of this blog. This actually came from a question raised by one of our

Continue reading

Power BI Calculation Groups – DAX Tutorial

Power-BI-Calculation-Groups-–-DAX-Tutorial

In this blog tutorial, I’ll show you how to use Power BI calculation groups to create custom groupings and an insightful visualization particularly if you are unable to add new tables and columns to your Power BI desktop. You can watch the full video of this tutorial at the bottom of this blog. This was

Continue reading

Time Comparisons In Power BI: This Year vs Last Year

Time Comparisons In Power BI: This Year vs Last Year

I want to go over how you can easily do time comparisons in Power BI and specifically calculate this year versus last year. I’m going to show you a couple of techniques that you can utilize for time comparisons like this. You may watch the full video of this tutorial at the bottom of this

Continue reading

SELECTEDVALUE DAX – Harvesting Slicer Selection

SELECTEDVALUE-DAX-–-Harvesting-Slicer-Selection

In this tutorial, I’ll show you how to harvest or capture a value inside a measure to reuse in another measure and achieve dynamic calculations. I use a combination of measure branching technique with SELECTEDVALUE DAX function in Power BI. You may watch the full video of this tutorial at the bottom of this blog.

Continue reading

Power BI Timesheet & Wages DAX Solutions

Power-BI-Timesheet-Wages-DAX-Solutions

This blog centers around a Power BI timesheet and the associated wage costs. I’m going to show you how to calculate time data and wage type using DAX. I’m going to demonstrate a DAX solution using measures and another one using calculated columns. You may watch the full video of this tutorial at the bottom

Continue reading