Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Solved

Calendar Table Omits Data

Buenos dias a Todos Create a Calendar Table | Calendar = CALENDAR(DATE(2020,01,01),DATE(2024,12,31)) also add the respective fields of month, year, day, etc. And I related it to my main data tabl...
  • Syndicate_Admin's avatar
    Syndicate_Admin
    2 years ago

    Hello @darioramadan thank you for your prompt reply,

    I inform you that your remark has been useful to me. In the Table view it was as a short date and I thought that was enough, but when I entered the Power Query editor and checked the source of the data, I realized that it was like DATETIME

    I just changed the type to DATE and now it does show all the total data.
    Really grateful < 3

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Hello @darioramadan thank you for your prompt reply,

I inform you that your remark has been useful to me. In the Table view it was as a short date and I thought that was enough, but when I entered the Power Query editor and checked the source of the data, I realized that it was like DATETIME

I just changed the type to DATE and now it does show all the total data.
Really grateful < 3

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, Syndicate_Admin 

Glad to hear you solved the problem yourself!  
If you can, please share your solution, which will be beneficial for future users to read this post. 

 

Best Regards

Yongkang Hua