Help with TOTALMTD

[Adams_Apple]

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!

[v-echaithra]

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]

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]

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.

[Ashish_Mathur · Accepted solution]

Hi,

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