Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Group | SN | CT |
A | SN1 | 4 |
A | SN2 | 5 |
A | SN3 | 3 |
*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 ?
???
I'd suggest you read this first and then you won't have to wait forever for somebody to give you an answer.
thank you for your reply.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |