Forum Discussion

AndySmith's avatar
AndySmith
Icon for Helper III rankHelper III
2 years ago
Solved

Time Intelligence function over any measure

Hi. Wondering if it is possible in Power BI to have time intelligence function that will wrap up any selected measure.

To give an example we have several sales metrics that we want to report on (potentially 100's of different metrics) - including the usual ones such as 'Sales $' or 'Sales QTY' . 

 

Rather than creating a sperate measure for each metric - is there a way of bringing in a time intelligence function that will perform this automatically?

 

So If we had a YTD, MTD, LYTD and MAT calculation - the report would calculate these for whatever metric we bring in to the report? (for example Slaes $, Sales QTY,COGS, Discount Sales Units)

 

Otherwise I need to create 100s of seperate measures/calcs which doesnt feel like the smart way to go