Forum Discussion
Solved
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? ...
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.
karinafreitass - establish a relationship with your date table to Credito/Debito.
Appreciate your kudos!! Mark this post as solution if this helps.