Forum Discussion

Hoping's avatar
Hoping
Icon for Helper III rankHelper III
3 years ago

Year as a Dimension

I am creating a shared dimension model where I have 3 Fact tables and 2 Dimensions. Both the dimensions are shared by all 3 Fact tables. 

 

I have a date dimension table in the in the source that I have pulled into power bi.  However, the fact tables do not have a date key but only a year column.  In the visual, I would like to filter the fact tables by year.  

 

The relationship between Year Dimension and the Fact table becomes a many-yo-many as there is no date key.

 

What is the best way to handle this scenario ?

 

1. Can I convert the years in the Fact to a date (may be 1/1/2023 where year is 2023), so that I can have a one-to-many relationship?

 

2. Have a many-to-many relationship between the Fact and Dimension (filter direction in this case ?)