TOTALYTD over many years

[geerduran]

I´m using

TOTALYTD(

        SUM('Datos Comparativo'[Baseline]),

        'Datos Comparativo'[Periodo].[Date]

    )

...and I get

Year Month  Baseline   TOTALYTD

2019  11        100           100

2019  12        100           200

2020  01        100           100

2020  02        100           200

I want this (summing over many years)

Year Month  Baseline   TOTALYTD

2019  11        100           100

2019  12        100           200

2020  01        100           300

2020  02        100           400

How can I use 4th parameter of TOTALYTD?

[AlB · Accepted solution]

Hi @geerduran 

TOTALYTD will sum only over one year, up to the date tha fourth parameter specifies

Try this

CALCULATE (
    SUM ( 'Datos Comparativo'[Baseline] ),
    FILTER (
        ALL ( 'Datos Comparativo'[Date] ),
        'Datos Comparativo'[Date] <= MAX ( 'Datos Comparativo'[Date] )
    )
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[geerduran]

Done!!! Thank you very much.