Forum Discussion
Helper IRetrieve value into one Dimension table into another dim table
Hi, nbitabc ;
I'm really sorry that I reconstructed the model, but there are still some deviations and I can't understand your logic. If you can modify it in my file and share the result you want to output, maybe it will be better? Or share your files after removing sensitive information? Looking forward to your reply!
Best Regards,
Community Support Team_ Yalan Wu
Community SupportHi， nbitabc ；
I'm really sorry that I can't fully understand the output result that your data model has been hoping for through your description. Based on my understanding, I made a simple sample:
1.simple file‘s model
2. create a column .(Here you could change the 'B' to 'Remote'.)
Column = IF([Office Location]="B",RELATED('dimension'[Region]),[Office Location])The final output is shown below:
If this doesn't work for your model, can you make a simple file with the result you want to output along with the scene?
The most important parts are:
1. Sample data as text or screenshots.
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Looking forward to your reply!
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IHi v-yalanwu-msft,
Thank you for your response.
In my case Region and Office location are two different Dimension tables and are not directly related. So RELATED functon will not work here.
Ideally would like a single combined column that can be used along with both Sales Fact and Inventory Fact table in a single table.
Example output -
Hope this is clear. Appreciate your assistance !