Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

utilisation vs capacity

Hi experts,   I am building a model to monitor the daily space utilization in the warehouse: Each warehouse contains tanks where is storage liquid.  For that porpouse I have 3 tables: - DimDate: ...
Need Help
  • StefanoGrimaldi's avatar
    StefanoGrimaldi
    4 years ago

    also you can over power query do the concatenate and remove the duplicates of the reference column in case 

StefanoGrimaldi's avatar
StefanoGrimaldi
Icon for Resident Rockstar rankResident Rockstar
4 years ago

you dont need a many to many relantionship for what Im seeing you just need to make a relantion between capacity and daily stock , cause date and capacity are dim tables that contain support data, the dailystock would be the fact table, 

link by tank id on both tables, you sould have only 1 capacity per tank I guess