Power Query Table - add formula if

[aam1932]

Hai

How to add formula if in Power query table. The formula as below

A	b	Formula	Final result
AAA		if(column B = empty, used description column a, used columb b	AAA
	AAA		AAA
BAAA	BB		BB
aa	ccc		ccc

<tbody>
</tbody>

Thank you

 

[Comfy]

Here you go:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"A", type text}, {"b", type text}}),
    #"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Custom", each if  = null then [A] else  )
in
    #"Added Conditional Column"

Excel 2010
	A	B	C	D	E	F	G
1	A	b		A	b	Custom
2	AAA			AAA		AAA
3		AAA			AAA	AAA
4	BAAA	BB		BAAA	BB	BB
5	aa	ccc		aa	ccc	ccc
6
Sheet1

 

[GorD]

Add custom column, then use formula below - i changed column headers to col1 and col2 rather than A and b

=if [Col1]=null then [Col 2] else [Col1]

Hope it helps