topic Re: DAX to concatenate text values in a column in DAX Commands and Tips

DAX to concatenate text values in a column

AMBP1973 — Thu, 16 Oct 2025 03:54:33 GMT

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! 🙂

Re: DAX to concatenate text values in a column

Jihwan_Kim — Thu, 16 Oct 2025 04:15:26 GMT

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] )

Re: DAX to concatenate text values in a column

v-dineshya — Thu, 16 Oct 2025 09:38:44 GMT

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

Re: DAX to concatenate text values in a column

Kedar_Pande — Thu, 16 Oct 2025 10:54:48 GMT

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

Re: DAX to concatenate text values in a column

AMBP1973 — Mon, 20 Oct 2025 01:16:23 GMT

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

Re: DAX to concatenate text values in a column

AMBP1973 — Mon, 20 Oct 2025 01:17:30 GMT

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