Forum Discussion

chenko90's avatar
chenko90
Frequent Visitor
6 years ago
Solved

Forming relationships with different data

Hi,  I am trying to create some relationships in my report and am running into issues. I have three different excel sources that i am using in one report. I need to be able to filter them all by mon...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago
    Hi chenko90,

    Create. Calendar table and a department table with unique values then use those table to relate all other tables that way you will have 1 to many relationships and will be able to make all the calculations on your model.
MFelix's avatar
MFelix
Super User
6 years ago
Hi chenko90,

Create. Calendar table and a department table with unique values then use those table to relate all other tables that way you will have 1 to many relationships and will be able to make all the calculations on your model.