Forum Discussion

clarainesgg's avatar
clarainesgg
Helper I
1 year ago
Solved

Acumulative Percentaje

Hi,   I need to calculate the accumulative % given cetain periods.     Thanks!  
Need Help
  • dharmendars007's avatar
    dharmendars007
    1 year ago

    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

    LinkedIN 

dharmendars007's avatar
dharmendars007
Memorable Member
1 year ago

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

LinkedIN