Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey All,
I'm trying to create a custom table from an existing table.
Existing
Area | Q1 | Q2 | Q3 |
A | 1 | 4 | 7 |
B | 2 | 5 | 8 |
C | 3 | 6 | 9 |
Expected
Area | Quarter | Value |
A | Q1 | 1 |
B | Q1 | 2 |
C | Q1 | 3 |
A | Q2 | 4 |
B | Q2 | 5 |
Used DATATABLE dax expression.
Table convert = DATATABLE("Area",STRING,"Quarter",STRING,"Value",INTEGER
,{
{"A","Q1",1},
{"B","Q1",2},
{"C","Q1",3},
{"A","Q2",4},
{"B","Q2",5},
{"C","Q2",6},
{"A","Q3",7},
{"B","Q3",8},
{"C","Q3",9}
}
)
Basically idea is to get each cell vallue and place it in new table accordingly. I tried LOOKUPVALUE to get the cell value dynamically inside DATATABLE. But it asks for value to be compared which i have to hard-code.
Is there a way to achieve this PBI.
Solved! Go to Solution.
HI @shreyas
Go into the Query Editor and select the Area Column and then use the "Unpivot other columns" feature.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |