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 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'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

3 Replies

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    2 years ago

    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

  • 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