Forum Discussion
Two fields in fact table to the same dimension table
Good day everyone, I'm having trouble modelling this. I have this fact table with two columns, one each for a voyage; 1) The voyage to our warehouse 2) The voyage from our warehouse Now I ...
Hi bcdobbs ,
One row in my fact table represents an entire trip (transport), so get goods somewhere, to our warehouse, and deliver them somewhere else. That's why I have both the voyage_in and voyage_out on the same row.
What would you suggest I do?
Thanks
I'd probably have two dimensions which could essentially be copies of each other. One being an origin dimension and another being a destination.
You then effectively have a factless fact table that describes transit between origin and destination.
As Maulik_Domadia said you could leave it
from one dimension and use USERELATIONSHIP in a measure but then you're moving a lot of work to dax rather than having a clear model.