if Statement with conditions from list

Question

Dear community members,&nbsp;Need support in Power Query data transformation.&nbsp;I have a column of Product Type column&nbsp;&nbsp;Product TypeBooksFurnitureTechnologyOffice SuppliesBooksBooksBooksOffice SuppliesTechnologyOffice Supplies&nbsp;The objective is to add one conditional column which takes input from a list to return required valueList:lstPrimeProductFurnitureOffice Supplies&nbsp;Output:Product TypePrime ProductBooks&nbsp;FurnitureYTechnology&nbsp;Office SuppliesYBooks&nbsp;Books&nbsp;Books&nbsp;Office SuppliesYTechnology&nbsp;Office SuppliesY&nbsp;Please advise.&nbsp;Thanksvir&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

vijay_a_verma · Accepted Answer

See the working here - Open a blank query - Home - Advanced Editor - Remove everything from there and paste the below code to testlet
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcsrPzy5WitWJVnIrLcrLLCktSgXzQlKTM/Lyc/LTK8Fc/7S0zORUheDSgoKczFSIBoRWbCxsOggZGgsA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Product Type" = _t]),
    lstPrimeProduct = {"Furniture", "Office Supplies"},
    #"Added Custom" = Table.AddColumn(Source, "Prime Product", each if List.Contains(lstPrimeProduct,[Product Type]) then "Y" else null)
in
    #"Added Custom"&nbsp;

Forum Discussion

if Statement with conditions from list

1 Reply

Related content

Dax IF/AND Statement with Null condition

IF statement and conditions

Condition Statement

Conditional Statement

Multiple Condition If Statements

Product Type	Prime Product
Books
Furniture	Y
Technology
Office Supplies	Y
Books
Books
Books
Office Supplies	Y
Technology
Office Supplies	Y