The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
We have recently implemented PowerBI in our organization and have been navigating around with DAX. Question is around RELATED function.
In our scenario, there are two fact tables, say Sales Fact and Inventory Fact both joined to three conformed dimensions - Customer, Office Location, Region.
Trying to create a conditional column in table view. Zone = IF Office Location = 'N/A' THEN Region ELSE Office Location.
However, PowerBI is only allowing to create this column in either of the Fact tables. We want to have it in one of the Dimension tables so it can be used independently with either Fact table like any other Dimension attribute.
Thanks for any assistance !
What is the best way to accomplish this? I know this can be done in Power Query but wanted to understand from DAX perspective.
Hi, @nbitabc
Not fully sure what is your question, can you elaborate a bit more, provide some screenshots to explain what you are trying to do.
If convenient, please share a simple example for testing.
Best Regards,
Community Support Team _ Eason
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
95 | |
84 | |
66 | |
61 |
User | Count |
---|---|
246 | |
124 | |
115 | |
79 | |
78 |