Forum Discussion
Automatic Cumulated Delta
Hello, i created the following table (please do not consider the chronology). I calculated the column "%" with the follwing measure: % = IF(ISBLANK(Tabelle1[2019 J]);BLANK();DIVID...
Hi Xue Ding,
sorry for the delay. I havent had time to test it. I will try to test it the next days.
Best Regards
Henning
Hi Xue Ding,
sorry for the delay. It works good in your file. In my file i have one column with the turnover from the last 3 finacial years. I sort them in different columns with the measure:
= CALCULATE(Sum('Übersicht'[Umsatz]);DATESBETWEEN('Übersicht'[Datum];"01.07.2017";"30.06.2018"))
So i have a column for each fiscal year. I can´t work with them in your meausre. I think beacuse its already calculated or what do you think?
Thanks in advance
Best Regards