new column that calculates value of a row based on text in the row

[leroy773]

All,

I am attempting to add an if function to a column to calculate quantity of a row based on part description.  I have tried search and contains functions to no success.  Anytime the part name contains partial I would like to multiply by one. since all other parts are whole, would like to multiply by 4.  Any feedback will be appreciated.

Part Name	Qty	Total
a, partial	1	='Qty'*1
a, whole	.5	='Qty'*4
b, partial	1	='Qty'*1
b, whole	.75	='Qty'*4

[Anonymous]

@leroy773 

Calculated column measure :

Measure=SWITCH(TRUE(),FIND("partial",[Part Name],1,0)>=1,[Qty]*1,[Qty]*4)

[leroy773]

Thank you for the prompt feedback, that calculation multiplies all qty by 1, even when partial is in the part name.  Any other thoughts.

[Anonymous · Accepted solution]

@leroy773  working fine for me: please use in the calculated column

[leroy773]

Thanks that worked, not sure why it did nto work.  Must of entered something incorrectly

[Anonymous]

Have U used this Measure: Measure=SWITCH(TRUE(),FIND("partial",[Part Name],1,0)>=1,[Qty]*1,[Qty]*4)

[amitchandak]

@leroy773 , Create a new column like

New column = [Qty] * Switch( True(), [Name] = "partial" , 1, [Name] ="whole",4,1)

[camargos88]

Hi @leroy773 ,

Try this column on Power Query:

if Text.Contains([Part Name], "partial") then 1 else 4 * [Qty]