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
Vasuno1's avatar
Vasuno1
Frequent Visitor
3 years ago

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: