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,
Please help me with below query:
Table1 Table2
I need the result as mentioned in table-2. Please help me with the same
Regards,
Chandra
Solved! Go to Solution.
Hi @Anonymous ,
You may refer to below formula:
Result2 = var a=RELATED(Table1[Result1]) return IF(a="N.A",Table2[Customers],a)
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi,
You could achieve this either by creating a custom column in power query
if [Result] = "N.A" then [Names] else [Result]
or creating a calculated column using dax
Column = SWITCH(Table[Result],"N.A",Table[Names],Table[Result)
Hi,
Hi,
Thanks for your response, I've shared the pbxi file for your reference about my need.
I Wish to expalin the same in below points
1. Table1 is a list of Unique Customers with Result1 which has N.A for some customers.
2. Table2, i created a calculated Column to get the results using RELATED Function, but in this case in Table2 Result2 Column, If the value in Table1 is N.A then the customer name should reflect ( Table2 Customer name should reflect in Result column).
https://drive.google.com/file/d/1OMK75SKXtvEfschaQW1jKMaubIrI0dxE/view?usp=sharing
Regards,
Hi @Anonymous ,
You may refer to below formula:
Result2 = var a=RELATED(Table1[Result1]) return IF(a="N.A",Table2[Customers],a)
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi All,
Please help me with the query.
Also, please suggest me if this is possible with "Custom Coumn" option.?
Appreciate your help
REgards.
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |