Forum Discussion
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...
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
Good!!
Just in case, something that has been happening to me is that the original date column has the time as well... And the calendar table doesn't generate them with hours... If so, go to the query and transform the column into date and no date time