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 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi StefanoGrimaldi thanks for your promt reply.

I have create a custon column in both tables to get an ID concatenating Tank & Location. But despite this, I have a many to many relationship because in the Capacity table there are different dates.

thanks!!

 

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

but teorically you dont need a date column on teh capacity table you coudl delete it, or does the capacity change by date for each tank ? 

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

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