MTD is returning Blank()

[wshahzad]

MTD is returning blank despite it has value in the underlaying data. I can provide the sample PBIX file.

[v-yuaj-msft]

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

[amitchandak]

@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=6LUBbvcxtKA

To 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.

[ToddChitt]

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.