Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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!

  • Anonymous's avatar
    Anonymous
    8 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

  • Anonymous's avatar
    Anonymous
    Not 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's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity 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.