Last answered:

23 Dec 2023

Posted on:

22 Dec 2023

1

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

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.

3 answers ( 0 marked as helpful)
Instructor
Posted on:

22 Dec 2023

0

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.

Posted on:

22 Dec 2023

0

What is Time intelligence?

Instructor
Posted on:

23 Dec 2023

1

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.

Submit an answer