Forum Discussion

karinafreitass's avatar
karinafreitass
Helper III
5 years ago
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? ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

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

     

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

  • amitchandak's avatar
    amitchandak
    5 years ago

    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.

     

amitchandak's avatar
amitchandak
Super User
5 years ago

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.