Forum Discussion
MTD and MTD LY Random problem
Hi there everybody, I have a very odd problem. So ive got the following calculations using DATESMTD and then Dates MTD for the last period. I get perfect correct results for Current YEAR, however las...
parry2k
Super User
Super UserAnonymous oh! I see .[date] means it has internal calendar table which is not recommended as a best practice.
Two things:
- mark your calendar table as date table (check my post here)
- turn off auto date/time in options
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡