Forum Discussion
Anonymous
4 years agoNot applicable
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 ...
Anonymous
4 years agoNot applicable
Hi Anonymous ,
You may consider using Lookupvalue() function to search the desired column.
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.