Forum Discussion
Calendar Table Showing Blank Values on Report View
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!
- Anonymous8 years ago
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.
2 Replies
- AnonymousNot applicable
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
Community Support
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.