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.
Note: omzet = revenue
Omzet PY.**bleep** = if(LASTDATE(Datum[Datum]) > TODAY(), BLANK(), CALCULATE([Omzet PY],FILTER(ALLSELECTED(Datum),Datum[Datum] <= MAX(Datum[Datum]))))
Omzet **bleep** = IF(LASTDATE(Datum[Datum]) > TODAY(), BLANK(), CALCULATE(SUM(Waardepost[Omzet]),FILTER(ALLSELECTED(Datum),Datum[Datum] <= MAX(Datum[Datum]))))
I already tried it on a different way. Just with creating new measures to calculate my own %. Just one problem, I just want the number of the last date (today). I tried a couple of techniques but none of them worked.
So my two questions:
1) Can i create a KPI with RT ?
2) Is it possible to just selected the lastest data from the table.
Kind regard
Soler
- Anonymous5 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
4 Replies
- AnonymousNot applicable
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
- AnonymousNot applicable
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.
- AnonymousNot applicable
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