Forum Discussion

manuellchavez's avatar
manuellchavez
Advocate I
6 years ago

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.