Tag: DAX Measures

Currency Rates In Power BI: Handling Missing Data

Hierarchies In Power BI Visualizations

In this tutorial, you’ll learn how to handle missing data in a currency rates table using DAX and power query. You’ll learn the different ways to manage the missing rates in your table and present them effectively in a dashboard in Power BI. You may watch the full video of this tutorial at the bottom

Continue reading

Pros & Cons of Quick Measures In Power BI

Pros & Cons of Quick Measures In Power BI

Today, I want to do an overview of quick measures and show you how they have evolved over time. I’ll talk about its pros and cons and then finish on what I think is a better alternative. You may watch the full video of this tutorial at the bottom of this blog. The reason for

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

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

Conditional Formatting In Calculation Groups – Power BI

Conditional-Formatting-In-Calculation-Groups-–-Power-BI

In this blog, I’m going to show you how you can apply conditional formatting to calculation items or groups in Power BI. Although conditional formatting is limited in calculation groups, you can still leverage some of its benefits effectively. You can watch the full video of this tutorial at the bottom of this blog. So

Continue reading