cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
benparody
Frequent Visitor

MTD not showing correctly on the 31st of the month

Hi

 

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])
 
Regards
Ben
 
3 REPLIES 3
v-jingzhang
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.

Greg_Deckler
Super User
Super User

@benparody You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000

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

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...


@ 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

Announcements
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