MTD Help

[tomsmith213]

Hi, I’m really new to power bi.

I need help understanding how the MTD calculation works.

It was my understanding this will show me last months up to the same date as today.

However my data is showing all of last months against this MTD instead? (I had no sales on 11th hence its not showing)

Below is the total in excel vs what power bi is calculating.

Power BI showing total sales for month of October below? (which is the correct value for the whole month, but i thought this MTD calc was only supposed to track it up to the same date as current?

Thanks for the help 🙂

[v-xiaotang]

Hi @tomsmith213 

Thanks for reaching out to us.

I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[djurecicK2]

Hi @tomsmith213 ,

 Please take a look at this article- it should explain everything:

https://radacad.com/power-bi-dax-previous-month-to-date-quarter-to-date-and-year-to-date-calculation...

[Greg_Deckler]

@tomsmith213 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...