Calendar Table Showing Blank Values on Report View

[Anonymous]

Hi guys.

I have an weird issue.

I created the CALENDAR table from the FACT table roughly like this:

StartDate = List.Min(XXXXX[YYYYY]),
EndDate = List.Max(XXXXX[YYYYY])
NumberOfDays = Duration.Days(Duration.From(EndDate-StartDate)),
Source = List.Dates(StartDate,NumberOfDays ,#duration(1,0,0,0))
TableFromList = Table.FromList(Source,Splitter.SplitByNothing(),{"Date"}),
ChangeType = Table.TransformColumnTypes(TableFromList,{{"Date", type date}})

It's got a relation, one to many with the FACT table, like normal.

There are other dimension tables too with one to many relations.

I am sure there are no blanks on the CALENDAR table and on the FACT table.

Anyway when I create a table visual on the report view, with fields from the multiple tables shown above, a misterious blank value appears for the date.

There's some data on the table visual for this selection.

I even created an ID column on the FACT table to check which entries were showing as (Blank) date. And the corresponding IDs have indeed a valid date on the FACT table.

This is quite weird, what can I be missing here?

Cheers, thanks in advance!

[Anonymous · Accepted solution]

I think what I did to solve it doesn't make sense, but I increased the CALENDAR table range on before and after the FACT table entries, and the blanks are gone.

[v-chuncz-msft]

@Anonymous,

DAX adds a new row to the related table that has blanks in every field, and links that new row to the unindexed row to guarantee referential integrity. You may drag date from a calendar table.