Why may need to have more than one relationship between the two tables?

Question

I don't understand why we have to have two relationships between two tables.
One key is not enough to link two tables?

I think you said this issue too early and I wish you would have left this issue after we became a bit more professional in PowerBi.

Answer 1

This is because you might be in a situation where you want to build measures for ShipDate and OrderDate. They require separate relationships to the dimension date table in order to build the time intelligence functions. It is not always necessary to have multiple relationships, usually one active relationship is enough, but in case you need more than one use the suggested solution.

Answer 2

Daniel Naseri

Posted on:

22 Dec 2023

0

What is Time intelligence?

Answer 3

Time intelligence is calculations such as Sales Last Month, MoM difference, This Year vs Last Year, etc. You need a date dimension table to achieve these results.

Why may need to have more than one relationship between the two tables?

Submit an answer

related questions