Forum Discussion

karkar's avatar
karkar
Icon for Helper III rankHelper III
9 years ago
Solved

IN OPERATOR in PowerBi

    I want to perform the following in Power Bi..   If Diagnosis_code  in('125','126', '127', '128') then category=Proc1 else if Diagnosis_code in('225','226', '227', '228') then category=Proc2 ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi karkar,



    Thanks for the reply. I need help with the syntax while creating a column in the query editor.

    Based on my test, the formula(M) below should work in your scenario. :smileyhappy:

    = if List.Contains({125,126,127,128},[Diagnosis_code]) then "Proc1"
else if List.Contains({225,226,227,228},[Diagnosis_code]) then "Proc2"
else null

     

    Regards