Forum Discussion
Acumulative Percentaje
Hi,
I need to calculate the accumulative % given cetain periods.
Thanks!
Hello clarainesgg ,
I'm not sure whetehr you are trying to create a logic in Power Bi or excel , if you are trying to create cumulative Qty then you can try the below measure..
CumulativeQty = CALCULATE(SUM(Table[Qty]),FILTER(ALL(Table),Table[Period] <= MAX(Table[Period])))
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!
Thank You
Dharmendar S
1 Reply
Hello clarainesgg ,
I'm not sure whetehr you are trying to create a logic in Power Bi or excel , if you are trying to create cumulative Qty then you can try the below measure..
CumulativeQty = CALCULATE(SUM(Table[Qty]),FILTER(ALL(Table),Table[Period] <= MAX(Table[Period])))
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!
Thank You
Dharmendar S