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

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    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 )
    )
    • amaniramahi's avatar
      amaniramahi
      Icon for Helper V rankHelper V
      7 years ago

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