Forum Discussion
MTD is returning Blank()
MTD is returning blank despite it has value in the underlaying data. I can provide the sample PBIX file.
3 Replies
- ToddChitt
Super User
Yeah, we're goint to need more than just the statement that "MTD is returning blank"
Can you describe the model (tables, fields, relationships in question)?
Can you give us sample data?
What is you DAX formula?
Is the fact table joined to a Date table?
Help us out, please.
- amitchandak
Super User
wshahzad , Are you using date table and time intelligence?
If yes refer to these two for why it can fail - https://www.youtube.com/watch?v=OBf0rjpp5Hw
https://www.youtube.com/watch?v=j0ug-XQgZtg
You can load pbix to dropbox or one drive and share.
Also check
Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKATo get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
- AnonymousNot applicable
Hi wshahzad ,
Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
Best Regards,
Yuna