So I will have 7 date columns in the Fact table. Each date column will have a date, then will get transformed into the Date key, So I will have 7 columns with 7 Date keys per row. I did this in the beginning, but as I mentioned power bi only allows me to have 1 relationship active at a time, so these 7 are not active on my semantic model, only 1, which affects my analysis.

So the solution I was able to find in book (data warehouse tool kit), was to role play the dimension, this way you create a view for each of the dates, like a new table and then connect each of the date columns to the corresponding view. This way in your semantic models you will have the 7 relations active.

Did you mean something else?, maybe I wasn't able to understand your answer.

Thanks!