Forum Discussion

Wedding55's avatar
Wedding55
Helper II
7 years ago

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...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Community Support
7 years ago

Hi Wedding55 ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Wedding55's avatar
    Wedding55
    Helper II
    7 years ago

    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

     

    • Wedding55's avatar
      Wedding55
      Helper II
      6 years ago

      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