Tag: HASONEVALUE

Ranking Analysis In Power BI: Advanced Insights From Combined Data Sets

In this tutorial, I’m going to show you some advanced ranking analysis in Power BI. As an example, I’m going to use the report that I submitted for the 10th Power BI Challenge on the Enterprise DNA forum. I have discussed the other pages in this report in other tutorials. For now, I would like

Continue reading

How To Work Through Extensive DAX Formulas In Power BI – Formatting Tips Included

How To Work Through Extensive DAX Formulas In Power BI – Formatting Tips Included

I’m going to show you how to work through complex DAX formulas. Extensive DAX formulas in Power BI are normally used if there are unique insights that you want to show on your reports. You can watch the full video of this tutorial at the bottom of this blog. One example of a scenario where

Continue reading

Using Advanced Logic In Power BI To Correct Your Totals

Many times when you get into more advanced formula with DAX, you’ll find that the totals that show up either on a table or a card can sometimes be incorrect. There are so many variations of how this could eventuate in your formulas so it’s hard to cover every single scenario. In this tutorial, I

Continue reading

Multiple What If Parameters In Power BI

Do you want to see how advanced you can get with Power BI? In this tutorial, I want to show you my favourite way to use Power BI. You can do some amazing work around scenario analysis by integrating what if parameters in Power BI — things like sales, profits, or transactions. You may watch

Continue reading