Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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, Chandr...
Tips and Tricks
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    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

Gordonlilj's avatar
Gordonlilj
Solution Sage
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

    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,

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi All,

       

      Please help me with the query.

       

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

       

      Appreciate your help

       

      REgards.

    • v-danhe-msft's avatar
      v-danhe-msft
      Microsoft Employee
      7 years ago

      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