Calendar Table Omits Data

[Syndicate_Admin]

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 table through a date field.

In the filters of my report those are the fields that I use to filter dates, but at the time of using them there is certain data that it does not show, although it works and filters me there are some that are lost, I look for them independently and if they are, but if I search for them filtering by dates, they do not appear.

EJ: I have 20 pieces of data associated with the month of January in my main table, if I search for them in a unique way, they all appear. but when I use the MES filter of my CALENDAR TABLE, I only see a smaller amount, maybe 7 or so.

I would appreciate any kind of help or advice
Thank you all very much, I look forward to answering

Best regards.

[Syndicate_Admin · Accepted solution]

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

[v-yohua-msft]

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

[Syndicate_Admin]

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