Question

What is the need of setting relationship between tables

Answer 1

Multiple relationships between tables. A Data Model can have multiple relationships betweentwo tables. To build accurate calculations, Excel needs a single path from one table to the next. Therefore, only one relationship between each pair of tables is active at a time.