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 ([Cl...
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
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