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

Percentage Of Total Using ALL And ALLSELECTED

Percentage Of Total Using ALL And ALLSELECTED

In this tutorial, I’ll discuss the difference between ALL and ALLSELECTED DAX functions when calculating the percentage of total in Power BI. The difference between these two DAX functions can be relatively confusing when you’re just starting out with Power BI. Hopefully, this tutorial can give you some clarity on this matter. You may watch the full

Continue reading

VALUES Function (DAX) In Power BI

VALUES-Function-DAX-In-Power-BI

In this tutorial, I’ll discuss how the VALUES Function (DAX) allows you to create a useful automation when working on a model with multiple date measures. You may watch the full video of this tutorial at the bottom of this blog. The VALUES function (DAX) returns a one-column table that contains the distinct values from

Continue reading

EDNA Learning Map: Updated to Allow Learning Plan Customization

The Enterprise DNA Education Platform has always been a comprehensive resource for all things Power BI. We’ve always strived to make the learning process a fulfilling one and we’ve laid out a path that helps Power BI users build a strong foundation, learn more advanced techniques as they go along, and eventually become experts in

Continue reading

ROUND Function in Power BI – Conditional Formatting

ROUND Function in Power BI – Conditional Formatting

In this tutorial, I’ll discuss how to use the ROUND function in Power BI when it comes to conditional formatting. Excel users might be familiar with how this function works in Excel, and we actually use it very similarly in Power BI. You may watch the full video of this tutorial at the bottom of this

Continue reading