Formula for calculated column in Power Query

[DevonVanDam]

Hello guys,

Can someone please help me translate these formulas from Excel, to make them suitable for Power Query's calculated column.

= IF ([Clearing document]="";"Open";"Closed")

= IF ([Clearing document]=[Document number];"Payment";"Invoice")

Thanks,

Devon

[amitchandak]

@DevonVanDam , In Dax

new column = IF (isbalnk([Clearing document]) || [Clearing document]=""  ,"Open","Closed")

new column = IF ([Clearing document]=[Document number],"Payment","Invoice")

[BA_Pete · Accepted solution]

Hi @DevonVanDam ,

Power query code as follows:

if [Clearing Document] = null or [Clearing Document] = "" then "Open" else "Closed"

if [Clearing Document] = [Document number] then "Payment" else "Invoice"

In Power Query, go to Add Column tab, then Custom Column and paste each of these lines in.

Pete