Forum Discussion
How to do accumulate using a measure?
Hello, i am creating a report for rentabiliti using the rules that my client wants. At this moment i am facing a problem that can't solve. I need to accumulate the rentabiliti of each month, using t...
I used the second measure and i got it simple acumulated.
Cumm Sum=
CALCULATE(sumx(values(dCalendario[Mes/Ano]),[02 Rent Final]) ,filter(all(dCalendario),dCalendario[Data]<=max(dCalendario[Data])))
But my rentabiliti is percentage, so i can'nt just sum, i need to do like:
((1+[02 Rent Final]){Month1} * (1+ [02 Rent Final]) ){Month1} -1 ......
It's possible?
Hi,
Your question is not clear. Share some data, explain the question and show the expected result. Share data in a format that can be pasted in an Excel file.