Running time comparison type analysis on custom calendars is a little bit more complex than if you were using a standard calendar. The reason behind this is because the time intelligence functions available for custom calendars allow users to quite easily and effectively write a formula and achieve the results that they want. Unfortunately with non-standard
This video tutorial is all about how you can run time intelligence calculations over custom calendars in Power BI. This is really relevant to those who deal with 445 calendars which is a very common scenario for Power BI users. Not all business out there work to a standard calendar around financial years or calendar
Recently I went about upgrading the DAX formula reference guide provided to all those connected with Enterprise DNA. At the same time I wanted to distribute it more widely as I know there is a huge requirement for a resource like this out there as the number of analysts using Power BI just grows and
It’s important for many businesses to make sure that you are analyzing over the correct sale period or correct time period in which you’d actually have results. Now if you implement formulas incorrectly in Power BI, especially over iterating functions like AVERAGEX or SUMX, and you iterate over days where you don’t actually have results
