TOTALYTD not working

[amaniramahi]

I have read the similar posts but nothing worked with me.

I have a table with months (the end of each month date) and the sales target for each month.

I need to calculate the YTD target 

the table is  below, YTD target should be 52, but when I try 

TOTALYTD(sum(Target[Target]),Target[Month].[Date]) it gives me the year total = 105

[MauriceMecowe]

Hi @amaniramahi 

You will need a continuous date selection for this to work.

Sincerely,

Maurice

[AlB · Accepted solution]

Hi @amaniramahi 

TOTALYTD does not work the way you expect it to. Check it out here

Try this instead:

Measure =
CALCULATE (
SUM ( Target[Target] ),
Target[Month] <= TODAY (),
Target[Month] >= DATE ( YEAR ( TODAY () ), 1, 1 )
)

[amaniramahi]

Thank @AlB ! that worked !

apology but I am new to power bi, I guess I will go through the whole website you provided!

Thanks again

[amaniramahi]

@MauriceMecowe  thanks for the reply.

I already have created a datetable with continuous dates and created a relationship between the datetable and the dates in this table. didn't work either 😞