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. ...
amitchandak
Super User
5 years agoluizsousa1 , 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
5 years agoNew 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: