Forum Discussion

alicemolk's avatar
alicemolk
Frequent Visitor
3 years ago
Solved

% cumulative

Hi everyone, How can I write the DAX to get % cumulative following this formula? Thank you!    
Need Help
  • v-xiaotang's avatar
    v-xiaotang
    3 years ago

    Hi alicemolk 

    Thanks for reaching out to us.

    first you need to select Transpose to get the below table

    then create the measure below

    Measure = AVERAGEX(FILTER(ALL('Table'),'Table'[date]<=SELECTEDVALUE('Table'[date])),[value])

    result

     

     

     

    Best Regards,

    Community Support Team _Tang

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

v-xiaotang's avatar
v-xiaotang
Community Support
3 years ago

Hi alicemolk 

Thanks for reaching out to us.

first you need to select Transpose to get the below table

then create the measure below

Measure = AVERAGEX(FILTER(ALL('Table'),'Table'[date]<=SELECTEDVALUE('Table'[date])),[value])

result

 

 

 

Best Regards,

Community Support Team _Tang

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