Forum Discussion

luizsousa1's avatar
luizsousa1
New Member
5 years ago

Filtar table calendar

Hello, everyone 

 

I have a table created with the Calendar function, which filters two other tables. However, when filtering using the date column of the calendar table, the results appear blank.

 

 

 

 

2 Replies

  • luizsousa1 , Not very clear with screenshot.

    If the one side on the table is giving null/blank values. It means there are values on many side which is missing on one side. It means date table do not have all the dates

    • luizsousa1's avatar
      luizsousa1
      New Member

      Hello, Thanks for your reply.

      Initially I thought the same, but I saw that the calendar table has all the dates.

      I created the calendar table like this:

       

      Calendario = CALENDAR ( MIN ( '1_viagens'[Data_solic] ), MAX('11_Transporte'[Data]))

       

      All dates table calendar:

       

       

      All dates table 1_viagens:

       

       

      All dates table 11_transportE: