Forum Discussion

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
6 years ago

KPIs using None Standard date Periods

say you have the following KPI based on a Monthly report Indicator: Fact Target Goal: Last Month fact Trend Axis Date (Month from the data hierarchy)   But I also have reports based on Tim...
Need Help
DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
6 years ago

This is my Flag for the Rolling 12 Months

Rolling 12 Month Flag = IF(DATEDIFF('dim Date'[date].[Date],TODAY(),MONTH)<=12 && DATEDIFF('dim Date'[date].[Date],TODAY(),MONTH)>=0 ,1,0)
 
And this is the one for Rolling Quarter
Rolling Quarter Flag = IF(DATEDIFF('dim Date'[date].[Date],TODAY(),MONTH)<=3 && DATEDIFF('dim Date'[date].[Date],TODAY(),MONTH)>0,1,0)
kentyler's avatar
kentyler
Icon for Solution Sage rankSolution Sage
6 years ago

It looks like the KPI indicator expects a set of dates. Perhaps you need a measure that selected the dates that have the correct flags....and then create the KPI over that.

It would help me if you could post a small sample power bi file.