79527782

Date: 2025-03-22 17:04:04
Score: 1.5
Natty:
Report link

The easiest way is the following

  1. Format your data as table ( Table name as MY_TEXT)

  2. Insert a pivot table and select country as row and region as column

  3. Right click the table ( from the field list - "Pivottable fields") and add measure.

  4. Create a new DAX formula CONCATENATEX(MY_TEXT,MY_TEXT[MyText])

  5. Add the above measure in the value.

Reasons:
  • No code block (0.5):
  • Low reputation (1):
Posted by: CA Thirunarayanan Srinivasan