DAX to concatenate text values in a column

[AMBP1973]

Hello,

I am seeking assistance for an appropriate measure to concatenate certain text values in a column to then = a single text value. This would be applicable to the listed items below from a single column. I am looking to acheive the following:

Site page, BMS Navigation Page, BMS BPAD = Web Page

Policy, Framework, Plan, Manual, Procedure, Instruction, Guide, Handbook = Documents

The remainder of the values in the column would remain as is.

Any assistance would be much apppreciated! 🙂

[Kedar_Pande · Accepted solution]

Create a calculated column:

Category =
SWITCH(
TRUE(),
'Table'[Column] IN {"Site page", "BMS Navigation Page", "BMS BPAD"}, "Web Page",
'Table'[Column] IN {"Policy", "Framework", "Plan", "Manual", "Procedure", "Instruction", "Guide", "Handbook"}, "Documents",
'Table'[Column]
)

Replace 'Table'[Column] with your actual table and column names.

If this answer helped, please click Kudos or mark as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande

[AMBP1973]

@Kedar_Pande @v-dineshya thankyou for your response and solution, works perfectly! 

[v-dineshya]

Hi @AMBP1973 ,

Thank you for reaching out to the Microsoft Community Forum.

Hi @Jihwan_Kim , Thank you for your prompt response.

Hi @AMBP1973 ,  Could you please try the proposed solution shared by  @Jihwan_Kim ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.

Regards.

Dinesh

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

I tried to create calculated column.

CC_slicer = 
SWITCH (
    TRUE (),
    slicer[slicer] IN { "site page", "bms bpad", "mbs navigation page" }, "web page",
    slicer[slicer]
        IN { "policy", "framework", "plan", "manual", "process", "prodecure", "guide" }, "documents",
    slicer[slicer]
)

[AMBP1973]

@Jihwan_Kim thankyou for providing this, unfortunately my organisation doesn't allow the PBIR