Forum Discussion

C4L84's avatar
C4L84
Advocate II
4 years ago

Addcolumn with if statement

Hi community,   I'm looking for some help with an ADDCOLUMN expression.   I need to add a new column called "RevenueType" in the BookingStatus table which groups BookingCodes A, R, H and CX as "C...
DAX
SpartaBI's avatar
SpartaBI
Community Champion
4 years ago

C4L84 i'm confused 😁 isn't it what I sent you?

C4L84's avatar
C4L84
Advocate II
4 years ago

SpartaBI I need to specifically use the ADDCOLUMN funtion, something like this:

 

RevenueType =

ADDCOLUMNS('Booking statuses',"RevenueType",

IF(MIN('Booking statuses'[BookingCode]) in {"A","R","H","CX"}, "Confirmed revenue", "Provisional")
)
 
But I am getting this error message: 
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
  • Ivn_rmr's avatar
    Ivn_rmr
    New Member
    3 years ago

    Hi, I know it has been a while since you posted your question. Did you come across with any solution? I am having the same issue.

    • tamerj1's avatar
      tamerj1
      Community Champion
      3 years ago

      Hi Ivn_rmr 
      Please explain your issue perhaps I can help. 

      With regard to this particular question, I can see that SpartaBI already provided a workable solution. However, the request of using ADDCOLUMNS function as per C4L84 is not clear as ADDCOLUMNS returns a table not a scalar value. 

  • Vasuno1's avatar
    Vasuno1
    Frequent Visitor
    3 years ago

    C4L84  - Sorry I didn't realize that you reiterated your absolute need to use the ADDCOLUMNS function (nor did I notice that someone already posted the exact solution I did 😞)

     

    C4L84  / Ivn_rmr  - I used the below formula to create the table using the ADDCOLUMNS function:

     

    RevenueType = ADDCOLUMNS('Booking statuses',"RevenueType",IF('Booking statuses'[BookingCode] in {"A","R","H","CX"},"Confirmed Revenue", "Provisional"))