Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

MTD not showing correctly on the 31st of the month



I'm using this formula for MTD at the moment, but now that we've rolled over to the 1st of the Feb, its not showing a full MTD value for January up to the 31st. It's been fine up until now, (as a daily report) but this now returns blank today. i should be seeing 1-31st Jan with this..


Any idea what im doing wrong please? 


Turnover MTD (€) = TOTALMTD(sum(onetouch_daily_account_summary_last_2_months[bet_eur]),'Calendar'[Date])
Community Support
Community Support

Hi @benparody 


I guess you may have misunderstood the use of MTD. In TOTALMTD function (DAX), it says the return value is "A scalar value that represents the expression evaluated for the dates in the current month-to-date, given the dates in dates." The current month-to-date means it begins on the first date of the current month and ends with the last date in the specified date column after applying specified filters.


So when you've rolled over to the 1st of the Feb, it calculates the total from 1st Feb instead of from 1st Jan because Jan is its previous month. 


If you want to calculate the running total always from 1st Jan, you may consider using TOTALYTD function


Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Super User
Super User

@benparody You may find this helpful -

Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

Apologies, but i find this very confusing. Hmm. 

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors