Forum Discussion
MTD Help
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 🙂
3 Replies
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-TITHW/m-p/434008Hi tomsmith213 ,
Please take a look at this article- it should explain everything:
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.
