Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Running total KPI

Hello    I'm creating a report with running totals from this year. I use a relative date-slicer.  I created two measures until date. If I put them in a KPI, it will display infinity at the target....
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    If so you could use TODAY() function to get today's date and use EDATE() or DATEADD() function to get next year today's date.

    Measure = CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[date]=TODAY()))

Measure 2 = CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[date]=EDATE(TODAY(),+12)))

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

If today is 01/02, I want the see the difference between RT 01/03/2021 and 01/03/2022.  When I load tomorrow new data. I want the see the difference between RT 02/03/2021 and 02/03/2022. 

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

If so you could use TODAY() function to get today's date and use EDATE() or DATEADD() function to get next year today's date.

Measure = CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[date]=TODAY()))

Measure 2 = CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[date]=EDATE(TODAY(),+12)))

 

Best Regards,

Jay

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for the solution!