Forum Discussion
Solved
Formula for calculated column in Power Query
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
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
2 Replies
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
DevonVanDam , In Dax
new column = IF (isbalnk([Clearing document]) || [Clearing document]="" ,"Open","Closed")
new column = IF ([Clearing document]=[Document number],"Payment","Invoice")
