Hello. Dax superman.
Could you save me with DAX..?
I have a "RawTableA".
and then, I have made and used a dax table serveral times.
Is there a way to make it all at once using Dax ?
RawTableA
| Group | SN | CT |
| A | SN1 | 4 |
| A | SN2 | 5 |
| A | SN3 | 3 |
| B | SN4 | 3 |
| B | SN5 | 6 |
| B | SN6 | 7 |
| C | SN7 | 5 |
| C | SN8 | 4 |
| C | SN9 | 3 |
*Create the ResultA Table for GroupA
-ResultA
| Group | SN | CT |
| A | SN1 | 1 |
| A | SN1 | 2 |
| A | SN1 | 3 |
| A | SN1 | 4 |
| A | SN2 | 1 |
| A | SN2 | 2 |
| A | SN2 | 3 |
| A | SN2 | 4 |
| A | SN2 | 5 |
| A | SN3 | 1 |
| A | SN3 | 2 |
| A | SN3 | 3 |
*and then, Create the New table by using ResultA
-ResultA-1 (Max Value for SN Coulmn)
*and then. I create the New ResultB table by using tables
-ResultB (ResultA-1 + TableA)
Listed in the order of values in group B after the min value in result A-1.
| Group | SN | CT |
| B | SN4 | 4 |
| B | SN4 | 5 |
| B | SN4 | 6 |
| B | SN5 | 5 |
| B | SN5 | 6 |
| B | SN5 | 7 |
| B | SN5 | 8 |
| B | SN5 | 9 |
| B | SN5 | 10 |
| B | SN6 | 6 |
| B | SN6 | 7 |
| B | SN6 | 8 |
| B | SN6 | 9 |
| B | SN6 | 10 |
| B | SN6 | 11 |
| B | SN6 | 12 |
*and then, Create the New table by using ResultB
-ResultB-1 (Max Value for SN Coulmn)
| Group | SN | CT |
| B | SN4 | 6 |
| B | SN5 | 10 |
| B | SN6 | 12 |
*and then. I create the New ResultC table by using tables
-ResultC (ResultB-1 + TableA)
Listed in the order of values in group C after the min value in result B-1.
ResultC (ResultB-1 + TableA)
| Group | SN | CT |
| C | SN7 | 7 |
| C | SN7 | 8 |
| C | SN7 | 9 |
| C | SN7 | 10 |
| C | SN7 | 11 |
| C | SN8 | 11 |
| C | SN8 | 12 |
| C | SN8 | 13 |
| C | SN8 | 14 |
| C | SN9 | 13 |
| C | SN9 | 14 |
| C | SN9 | 15 |
..
..
Final Ctreat Result
Union (ResultA, ResultB, ResultC)
Is there way how to create tables without using many creating table ?
