Tag: Time Intelligence

Time Intelligence For Non Standard Date Tables In Power BI

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

Continue reading

Previous Weeks Sales – Advanced Time Intelligence w/DAX in Power BI

Calculating the difference between weekly sales results in Power BI is unfortunately not that easy. The reason behind this is that Power BI doesn’t have a weekly based, built-in time intelligence function. The only available options are for the day, month, quarter, and year. Therefore, to be able to work out weekly results in Power

Continue reading

Month On Month Change For Custom Calendars In Power BI – 445 Calendars

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

Continue reading

Handling Weekday vs. Weekend Dates in Power BI Using DAX

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

Continue reading