Unexpected Blank dates on a data model

[NimaM]

Hi,

I have a fact table and a date dimension table in my power query model. There is no Blank on the date filed of the data source, and it doesn't even seem to exist in the imported data to the model, however, when I create a simple report based on dates, I see a bunch of blanks! I have no idea where they are coming from. 

[hnguy71 · Accepted solution]

Hi @NimaM ,

This assumes that there is a referential integritiy violation with your data. You have more data from either your fact table, dimension, and/or date table. Here's a great blog post on RI violations. Can you check this and see if you see any RI violations?

https://dax.tips/2019/11/28/clean-data-faster-reports/

[NimaM]

Thank you! That was it, RI.