Forum Discussion
Relationship with calendar Table
Hi everyone, I have two Fact tables that i want to relate to a Calendar calendar but when i see the values in the matriz is something wrong. As you see in the picture one, i use a bridge table with...
Hi Anonymous
Your fact tables and calendar table are connected with [year] column, so when filtering table on [month], it would show incorrect value.
If you fact tables have [year] and [month] columns, you can create a column=[year]&[month], then create [year]&[month] column in your calendar table, create relationships between them.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HI Anonymous ,
I think you need to make your relationships bi-directional, in-order to get the data filtered.
Thanks,
Pragati