Category Archives: Power BI, DAX

Finding common maximum in Power BI

Let’s get straight into the problems. Problem #1 You get country sales data on monthly basis. But, some of the countries i.e. Switzerland and Italy lag the others. Let’s imagine a scenario when all countries latest data (June-2020) has arrived … Continue reading

Posted in Power BI, DAX | Tagged , , , , , , , , | Leave a comment

Links in Power BI

This is just a compilation of different types of linking mechanisms in Power BI. I have explained them from use case point of view. It’s mainly written for newbies like me who are wondering which linking feature is applicable for … Continue reading

Posted in Power BI, DAX | Tagged , , , , , | Leave a comment

Non-additive measures with different granularity in Power BI

I have found many articles on web regarding non-additive measures in power BI. But most of them are about inventory-type measures where normal aggregate functions are not suitable for use. However, in real life we often face situations where data … Continue reading

Posted in Power BI, DAX | Tagged , , , , , , , | 2 Comments