Forum Discussion
manuellchavez
6 years agoAdvocate I
DAX to M - Cumulative Performance Formula
Hello,
I am trying to move this formula from a calculated column in DAX to a dataflow, but I am having trouble rewriting it on M.
The formula is the following:
CumulativePerformance = 100*EXP(SUMX(FILTER(Table , Table[Date]<=Earlier(Table[Date]) && Table[Group1]=Earlier(Table[Group1]) && Table[Group2]=Earlier(Table[Group2]) ),ln(Table[Return] +1) ) )
The result should be something like this:
Or if you know a better way to get the same result please share.
Thank you in advance.
1 Reply
- v-lili6-msftCommunity Support
Here are two similar links for your reference:
How to do a running Sum by group in Power Query?
Create Running Totals in Power Query
Regards,
Lin