Forum Discussion
If condition
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
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
4 Replies
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,