If condition

[Anonymous]

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

[Gordonlilj]

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)

[Anonymous]

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,

[v-danhe-msft · Accepted 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

[Anonymous]

Hi All,

Please help me with the query.

Also, please suggest me if this is possible with "Custom Coumn" option.?

Appreciate your help

REgards.