Multiple dates column

[Anonymous]

Dear 

How can we relate(or work)  between Fact table that multiple date columns(ex: mr date, rfq date, bc date, tbe date, awr date, po date etc and more) and dates table(column date,month,qtr,year)

[Fowmy]

@Anonymous 

You can create Active and InActive relationships between Dates and Fact tables then use USERELATIONSHIP function in your calculations:

https://www.youtube.com/watch?v=X9rkpt7-LNQ
https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive

[Anonymous]

First thanks for your reply,

we can do like that but i have more than 15 dates column in Fact table

Once we create relation between two tables more than 15, may be performance will be degrade

is there any better solution apart from creating more relationships ??

Waiting for community reply

[Fowmy]

@Anonymous 

I am not sure if you are using all those dates columns in the fact table. When you have many relationships, they will not degrade unless they are used in your calculations. Wherever you need to activate the inactive relationship only, you can use it.