Forum Discussion
luizsousa1
5 years agoNew Member
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
- amitchandak
Super User
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
- luizsousa1New 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: