Forum Discussion
utilisation vs capacity
also you can over power query do the concatenate and remove the duplicates of the reference column in case
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
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!!
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 ?
also you can over power query do the concatenate and remove the duplicates of the reference column in case