Wrong values coming in location B rather than chosen in location A through Conditional column functi

[samoberoi]

Hi,

I try to create a conditional column in which i choose e.g -

IF "READ" CONTAINS "A" THEN "HILL"

IF "READ" CONTAINS "B" THEN "HILL" 

IF "READ" CONTAINS "C" THEN "HILL" 

IF "READ" CONTAINS "D" THEN "HILL" 

ELSE "DAR"

Most of the values are showing right when i put those in filter, but there are a few values showing up in "DAR" rather than in "HILL", which otherwise should show up in "HILL" as chosen.

Help will be appreciated.

Thanks

[TomMartens]

Hey @samoberoi ,

please provide sample data and the exact formula, I have to admit that I'm not able to determine if you are trying to create the column using DAX or Power Query's M.

Regards,

Tom

[samoberoi]

The main objective is to put the locations in a column in 4 buckets. e.g:- A,B,C,D should go to HILL;  E,F,G,H should go in the bucket DAR; I,J,K should go to bucket COB and so on.

[v-rzhou-msft · Accepted solution]

Hi @samoberoi ,

You can create a custom column in Power Query Editor by below code.

if 
List.Contains( {"A","B","C","D"},[READ]) 
then 
"Hill" 
else if
List.Contains( {"E","F","G","H"},[READ])
then
"DAR"
else
"COB"

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[samoberoi]

Hi
It is just a simple conditional column i try to create in Power Query. 
Hope that makes it more clear.

Thank you