DAX has a lot of nice functions to make Time Intelligence with Months and Quarters easy. But what if your company uses its own Calendar with custom months and quarters like in the 4-4-5 or 5-4-4 system?
This article explains how to create a calendar table in Power BI Desktop in 5 minutes.
If you want to do some custom Time Intelligence (like below) or create Calculated Columns in a Date table then this Cheat Sheet can be very handy.
In this article you will learn how to apply conditional formatting in Power BI. The first part of this blog explains the basics of Conditional Formatting: where to find it and how to apply the different formatting options. The second part contains three step-by-step cases.