Forum Discussion

MatSantos's avatar
MatSantos
Regular Visitor
4 years ago

Sum Acumulate using 3 measures

Hi,

I need some help.

I have to create a sum acumulating the diference between 3 measures.

These measures are from diferent files.

The rule is: Evolução = PV - FAT - CART in january. 

In February is the some, but need to add the value of january.

Incorrect

 

Would be

 

Thanks for the help.

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    MatSantos , Assume these are measures

     

    CALCULATE([PV] - [FAT] - [CART] ,filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

     

     

    example

    Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

  • MatSantos's avatar
    MatSantos
    Regular Visitor
    4 years ago

    I'm confused with this part of the measure ('Date'),'Date'[date].

    I use the dCalendario[Data].[Mês] how month. 

    The return of dCalendario[Data].[Mês] are Janeiro, Fevereiro, etc...