Forum Discussion
Transform pivot table with two coluns
Hello, I need a help, I do a a pivot table like this: And I need transform in something like this, include one more colunm But using DAX expression, anybody help me? T...
Hi Anonymous ,
I assume each of the columns you show is a measure on your model, what you need is to add a table with the following setup:
Category SortCategory Measure MeasureSorting Mes Atual 1 Meta Vol. 1 Mes Atual 1 Realizado 2 Mes Atual 1 % Ating. 3 Acumulado trimestre 2 Meta Pos. 4 Acumulado trimestre 2 Pos Acumulado 5 Acumulado trimestre 2 % Ating Pos. 6 Acumulado trimestre 2 Meta Vol. Acumulado 7 Acumulado trimestre 2 Real Vol. Acumulado 8 Acumulado trimestre 2 % Ating. 9 Now add the following measure:
Value Total = SWITCH(SELECTEDVALUE(Table[MeasureSort]), 1, [Meta Vol.], 2, [Realizado], 3, [% Ating.], 4, [Meta Pos.], 5, [Pos Acumulado], 6, [% Ating Pos], 7, [Meta Vol. Acumulado], 8, [Real Vol. Acumulado], 9, [% Ating.])Now use the Category and the Measure of the previous table in the columns of the matrix and the measure on the values, should give expected result.
MFelix
Super User
Super UserHi Anonymous ,
I assume each of the columns you show is a measure on your model, what you need is to add a table with the following setup:
| Category | SortCategory | Measure | MeasureSorting |
| Mes Atual | 1 | Meta Vol. | 1 |
| Mes Atual | 1 | Realizado | 2 |
| Mes Atual | 1 | % Ating. | 3 |
| Acumulado trimestre | 2 | Meta Pos. | 4 |
| Acumulado trimestre | 2 | Pos Acumulado | 5 |
| Acumulado trimestre | 2 | % Ating Pos. | 6 |
| Acumulado trimestre | 2 | Meta Vol. Acumulado | 7 |
| Acumulado trimestre | 2 | Real Vol. Acumulado | 8 |
| Acumulado trimestre | 2 | % Ating. | 9 |
Now add the following measure:
Value Total =
SWITCH(SELECTEDVALUE(Table[MeasureSort]),
1, [Meta Vol.],
2, [Realizado],
3, [% Ating.],
4, [Meta Pos.],
5, [Pos Acumulado],
6, [% Ating Pos],
7, [Meta Vol. Acumulado],
8, [Real Vol. Acumulado],
9, [% Ating.])
Now use the Category and the Measure of the previous table in the columns of the matrix and the measure on the values, should give expected result.