Forum Discussion

Adams_Apple's avatar
Adams_Apple
Frequent Visitor
1 year ago
Solved

Help with TOTALMTD

I'm hoping you guys can help me yet again. I've dived through all the other TOTALMTD posts and haven't had any luck.

I am trying to setup a line chart that shows the running total each month. The data is only posted once a week, so I need to filter out the dates between Today and the Post date. I can get the running total to work, but anytime I add in the filter it destroys the running total chart.

 

Measure:     (I've tried wrapping it in CALCULATE and several other approaches, seems to be the same result)

Labor Amount MTD = TOTALMTD(SUM('Labor'[Labor Amount]), 'Ref - Dates'[Date], FILTER('Ref - Dates','Ref - Dates'[Date] <= [Last Posting Date]))

 

If I remove the Filter, it works:

Labor Amount MTD = TOTALMTD(SUM('Labor'[Labor Amount]), 'Ref - Dates'[Date])//, FILTER('Ref - Dates','Ref - Dates'[Date] <= [Last Posting Date]))

 

 

Thank you!

Need Help

4 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    1 year ago

    Hi,

    Restrict the last date of the Calendar table till today's date.

  • v-echaithra's avatar
    v-echaithra
    Community Support
    1 year ago

    HI Adams_Apple ,

    We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

    Regards,
    Chaithra E.

  • v-echaithra's avatar
    v-echaithra
    Community Support
    1 year ago

    Hi Adams_Apple ,

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

     

    Regards,

    Chaithra E.

  • v-echaithra's avatar
    v-echaithra
    Community Support
    1 year ago

    HI @Adams_Apple ,

    We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

    Regards,
    Chaithra E.