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

      • kentyler's avatar
        kentyler
        Solution Sage
        6 years ago

        Sometimes when I'm blocked I try and do things a different way. Maybe instead of using your flags you can use a function like 

        DATESINPERIOD

        • 12/09/2018
        • 2 minutes to read
            •  
           
          •  

        Returns a table that contains a column of dates that begins with the start_date and continues for the specified number_of_intervals.

        Syntax

        DAXCopy
         
        DATESINPERIOD(<dates>,<start_date>,<number_of_intervals>,<interval>)

        Parameters

           
        TermDefinition
        datesA column that contains dates.
        start_dateA date expression.
        number_of_intervalsAn integer that specifies the number of intervals to add to or subtract from the dates.
        intervalThe interval by which to shift the dates. The value for interval can be one of the following: year, quarter, month, day

        to develop your non-standard periods... and then you should have the date value to put in your KPI