Forum Discussion

DevonVanDam's avatar
DevonVanDam
Helper I
6 years ago
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...
Need Help
  • BA_Pete's avatar
    BA_Pete
    6 years ago

    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

     

amitchandak's avatar
amitchandak
Super User
6 years ago

DevonVanDam , In Dax

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

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