Power Query Data - add column with formula

[aam1932]

Hai

Can we add column in power query data and add formula. I want to add column add new formula, if the d/c is C, the amount should be negative sign (-) , if not is as per dataa

Example,

Amount	D/C	Add Column - New Column with formula
50	C	-50
50	D	50
100	C	-100

<tbody>
</tbody>

 

[Comfy]

You can use an if statement.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Amount", Int64.Type}, {"D/C", type text}}),
    #"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Custom", each if [#"D/C"] = "C" then [Amount] * -1 else [Amount] )
in
    #"Added Conditional Column"

 

[aam1932]

Thank you, perfect