Time Intelligence function over any measure

[AndySmith]

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

[Ritaf1983 · Accepted solution]

Hi @AndySmith 
Take a look at calculated groups

https://databear.com/calculation-groups-in-power-bi/

https://www.sqlbi.com/calculation-groups/

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.