Forum Discussion
Solved
pivot table column as text
I have a pivot table with "products" combined in to "areas" with a sum column of "quantities". I want to add the "units of measure" (UOM) next to the corresponding quantities. There are various uni...
Add the Range to the Data Model.
Right Click > Add Measure
Write DAX measure as:
=CONCATENATEX(Range,[quantities] & " " & Range[UOM], ", ")Returns:
Then you can just remove Subtotals and Grand Total.
You could also review https://www.sqlbi.com/articles/using-concatenatex-in-measures/ for a more complex application.
Add the Range to the Data Model.
Right Click > Add Measure
Write DAX measure as:
=CONCATENATEX(Range,[quantities] & " " & Range[UOM], ", ")Returns:
Then you can just remove Subtotals and Grand Total.
You could also review https://www.sqlbi.com/articles/using-concatenatex-in-measures/ for a more complex application.
