Addcolumn with if statement

[C4L84]

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 "Confirmed revenue" with all remaining codes as "Provisional".

Here is a pbix example.

I've got as far as creating the if statement: 

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

But can't figure out how to add this column to the table as I am getting and error that reads "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

It should be noted that this has to be a DAX expression and the data cannot be modified in the query editor.

I'm hoping someone in the community can help as I've been stuck on this for some time!

[Vasuno1]

I am not sure that you need to use the addcolumn function for this but if you really need to let me know.

I achieved what you are looking for by adding a new column as shown below:

Then I inputted the following in the formula bar:

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

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

See result below:

[SpartaBI]

@C4L84 do you mean like this?

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

Here is a link to download the file with the solution:
Addcolumn with if statement 2022-08-02.pbix

      

Showcase Report – Contoso By SpartaBI

[C4L84]

Thanks for replying @SpartaBI 

I need to add a new column to the BookingStatus table using DAX, which uses the IF statement.

[SpartaBI]

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

[C4L84]

@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.

[Vasuno1]

@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"))

[Ivn_rmr]

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]

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.