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.

alicemolk's avatar
alicemolk
Frequent Visitor
3 years ago

1-11-2022, 2-11-2022, ... is normal date. And the cumulative number is base on a number of day

 

BTW, I have already tried your suggestion but it doesn't work