Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have a requirement to create custom column rom different tables.
Below is the scenario.
if ('Region_Table'[RGN_CODE]='APAC' and 'Products_Table'[Product Line] = 'RD79') then ('ABC')
else if ('Region_Table'[RGN_CODE]='EMEA' and 'Products'[Product Line] in ('RD79','RD80')) then ('EFG')
else ('XYZ')
Thanks in Advace.
You may create a calculated column in Region_Table as below.Please make sure the two tables are linked as One to One or One(Products_Table) to More(Region_Table) in relationship view.
Column = IF ( Region_Table[RGN_CODE] = "APAC" && RELATED ( Products_Table[Product Line] ) = "RD79", "ABC", IF ( Region_Table[RGN_CODE] = "EMEA" && RELATED ( Products_Table[Product Line] ) IN { "RD79", "RD80" }, "EFG" ) )
Regards,
Cherie
Hi @v-cherch-msft ,
Thank you for your reply,
Actually these two dimension tables don't have direct relationship. These two dimensions are joined to FACT_SALES table.
Can you plesae advice.
Thanks,
RajKiran
You may use LOOKUPVALUE function.If you need further help,please share some data sample. You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.
Regards,
Cherie
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |