Forum Discussion
Dynamic filter
Hi guys,
I created the dimension table from 2020 to 2029.
The filter loads every future year
What can I do to filter only the years contained in the Crédito and Débito table? In this case it contains only the year 2020
Thanks
Karina
karinafreitass - establish a relationship with your date table to Credito/Debito.
Appreciate your kudos!! Mark this post as solution if this helps.
karinafreitass Join the date to other tables with Date of date table.
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
2 Replies
karinafreitass - establish a relationship with your date table to Credito/Debito.
Appreciate your kudos!! Mark this post as solution if this helps.
karinafreitass Join the date to other tables with Date of date table.
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.