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.

amitchandak's avatar
amitchandak
Super User
3 years ago

alicemolk , Seem like Avg Cumulative 

 

Try with help from date table

 

Cumm Sales = calculate(Averagex(Values('Date'[Date]) , CALCULATE(SUM(Sales[Sales Amount]) ) ,filter(all('Date'),'Date'[date] <=max('Date'[date])))

 

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.