MTD not showing correctly on the 31st of the month

[Anonymous]

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

[v-jingzhang]

Hi @Anonymous 

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]

@Anonymous 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-TITHW/m-p/434008

[Anonymous]

Apologies, but i find this very confusing. Hmm.