Forum Discussion

Roberto_F's avatar
Roberto_F
New Member
2 years ago

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...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

Roberto_F , Assuming you are using a date table, you can have measures like

 

Cumm Sum = CALCULATE(sumx(values('Date'[Date]),[02 Rent Final]) ,filter(all('Date'),'Date'[date] <=max('Date'[date])))

 


Cumm Sum = CALCULATE(sumx(values('Date'[Month Year]),[02 Rent Final]) ,filter(all('Date'),'Date'[date] <=max('Date'[date])))

  • Roberto_F's avatar
    Roberto_F
    New Member
    2 years ago

    Hello amitchandak , thanks for your help.

     

    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?
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Roberto_F ,

       

      You can change the final data format to percentage with this function:

       

      Hope it helps!

       

      Best regards,
      Community Support Team_ Scott Chang

       

      If this post helps then please consider Accept it as the solution to help the other members find it more quickly.