Forum Discussion
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....
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
Hi Anonymous ,
I haven't heard that we can't create a KPI with RT. And when you saying " just select the latest data from the table" are you meaning default select latest date in the slicer?
Best Regards,
Jay
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.
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
Thanks for the solution!