Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Issue with calendar table only returning year 1900

 

Hi everyone,

 

I am at a loss.  Probably something very simple though.  I built a calendar table in PQ.

 

 

Pretty straight forward.  But when I try to use that table in a visual the dates are not there.  I have also tried importing another calendar from Excel that has worked before with the same '1900' result.  

 

 

Any help is greatly appreciated!

 

Thanks,

Brian

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Your first image looks like it comes from Power Query. How does the data look in the data model itself?