Weekend Work 017 – Time Intelligence in DAX and a Peek at Demo 1

This week we looked at Time Intelligence within Power BI. Time Intelligence Calculations are something that you will find you use in almost all your projects. In this demo, we take you through how we add a Year To Date Measure and a Previous Year Measure. From there it is then possible to create a percentage change so we go through doing that, last it is important to understand the context of change so we calculate an average percentage change.

Inspections YTD = TOTALYTD( [Inspections], 'Calendar'[Dates])

Inspection YTD2 = CALCULATE( [Inspections], DATESYTD('Calendar'[Dates]))

Previous Year = CALCULATE([Inspections], 
                       SAMEPERIODLASTYEAR(
                               DATESYTD('Calendar'[Dates])
                               )
                        )

pct Change = 
    DIVIDE([Inspections YTD],[LY])

AVG pctChange = AVERAGEX(
              ALLSELECTED('Calendar'[Year]),
              [pct Change]
                        )

In order to support people in their growth and development cycles, we have built a training course to support DA-100 preparation. Having gone through the course and presenting previous Microsoft course across Europe we are pleased to be able to offer this course. Check our site for information on the group courses and if you want to do something with your business, then we can set that up for you as well. We look forward to hearing from you. Remember our Angels of the North can attend these courses for free! Another great perk!

%d bloggers like this: