Show text as value Power Pivot using DAX formula
06:32 02 Nov 2018

Is there a way by using a DAX measure to create the column which contain text values instead of the numeric sum/count that it will automatically give?

In the example below the first name will appear as a value (in the first table) instead of their name as in the second.

enter image description here

Data table:

+----+------------+------------+---------------+-------+-------+
| id | first_name | last_name  |   currency    | Sales | Stock |
+----+------------+------------+---------------+-------+-------+
|  1 | Giovanna   | Christon   | Peso          |    10 |    12 |
|  2 | Roderich   | MacMorland | Peso          |     8 |    10 |
|  3 | Bond       | Arkcoll    | Yuan Renminbi |     4 |     6 |
|  1 | Giovanna   | Christon   | Peso          |    11 |    13 |
|  2 | Roderich   | MacMorland | Peso          |     9 |    11 |
|  3 | Bond       | Arkcoll    | Yuan Renminbi |     5 |     7 |
|  1 | Giovanna   | Christon   | Peso          |    15 |    17 |
|  2 | Roderich   | MacMorland | Peso          |    10 |    12 |
|  3 | Bond       | Arkcoll    | Yuan Renminbi |     6 |     8 |
|  1 | Giovanna   | Christon   | Peso          |    17 |    19 |
|  2 | Roderich   | MacMorland | Peso          |    11 |    13 |
|  3 | Bond       | Arkcoll    | Yuan Renminbi |     7 |     9 |
+----+------------+------------+---------------+-------+-------+
excel dax