Dynamic filter

[karinafreitass]

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

[Anonymous · Accepted solution]

@karinafreitass - establish a relationship with your date table to Credito/Debito.

Appreciate your kudos!! Mark this post as solution if this helps.

[amitchandak · Accepted solution]

@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.

[Anonymous · Accepted solution]

@karinafreitass - establish a relationship with your date table to Credito/Debito.

Appreciate your kudos!! Mark this post as solution if this helps.