Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
General Comment
Need Help
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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.

     

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

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.