Forum Discussion

DebbieE's avatar
DebbieE
Community 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
kentyler's avatar
kentyler
Solution Sage
6 years ago

This may have to do with how you created your custom time periods. Can you give us an example of how you "set a flag". Thanks

  • DebbieE's avatar
    DebbieE
    Community 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
      Solution 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.

      • DebbieE's avatar
        DebbieE
        Community Champion
        6 years ago

        Unfortunately this is embedded in a large file for a customer which I cant share

        I always throught for the KPI you had to use date information from a hierarchy for this, so it makes sense that it cant use my flag? But I dont know what to do instead