Forum Discussion

janainacarmo's avatar
janainacarmo
Regular Visitor
6 years ago

Cumulate quantity

Hello Guys!   Please, see if you guys can help me with this question. I have to calculate the accumulate year to year of quantity, as example below:   A car has to have his oil changed every yea...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

janainacarmo ,

 

You may modify your measure using dax below:

measure =
CALCULATE (
    SUMX ( TIV; [Valor] );
    FILTER (
        ALLEXCEPT ( TIV; TIV[Linha]; TIV[Segmento] );
        TIV[Brand] = "Other"
            && 'TIV'[year] IN VALUES ( 'TIV'[year] )
    )
)

Community Support Team _ Jimmy Tao

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

janainacarmo's avatar
janainacarmo
Regular Visitor
6 years ago

Dear v-yuta-msft ,

 

Thank you for your reply, but this index is not working as cummulative...it is just counting the value year per year.

 

Thank you for your supporting until now.

 

Best Regards, Janaina