Forum Discussion

ADP007's avatar
ADP007
Icon for Helper IV rankHelper IV
9 years ago
Solved

TOTALYTD not working

Hi,

 

Really can't figure out why TOTALYTD is not working. Have seen the tutorial, read the posts here but can't get it to work.

 

I'm trying to have a running sum for each month.

 

Any help is more than welcome

 

David

 

YTD = TOTALYTD(sum(Query1[SaleNetNet]);Query1[InsertionDate_dt];all(Query1[InsertionDate_dt]))

 

Need Help

35 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Try without the last part:

    YTD = TOTALYTD(sum(Query1[SaleNetNet]);Query1[InsertionDate_dt])

    • ADP007's avatar
      ADP007
      Icon for Helper IV rankHelper IV
      9 years ago

      Same result. Have the same also when using CALCULATE function.

      Thanks

      D.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Wait. Now I see.

        The problem is that you don't use CalendarTable

        Do you have one in your model?