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