DatesYTD for more than one year

[pawelj795]

Hi,
I have a measure which sum cumulatevily inventory value for whole 2019.

Now, 2020 started, so my measure show 0 which is understandable.

Is it possible to start current year with value from 31.12.2019?

Also, the value should sum since 01.01.2019, not earlier.

My measure YTD are below.

[AlB]

Hi @pawelj795 

Try this

YTD Value =
CALCULATE ( SUM ( Table1[Col1] ), DimDates[Date] >= DATE ( 2019, 12, 31 ) )

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

Cheers  

[pawelj795]

@AlB 

Your solution not suming YTD (cumulatevily) at all.