Forum Discussion

amaniramahi's avatar
amaniramahi
Icon for Helper V rankHelper V
7 years ago
Solved

TOTALYTD not working

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...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    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 )
    )
MauriceMecowe's avatar
MauriceMecowe
Icon for Resolver II rankResolver II
7 years ago

Hi amaniramahi 

 

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

 

Sincerely,

Maurice

amaniramahi's avatar
amaniramahi
Icon for Helper V rankHelper V
7 years ago

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 :(