Create the table using generateseries

[ChoiJunghoon]

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 ? 

[daxer-almighty]

???

I'd suggest you read this first and then you won't have to wait forever for somebody to give you an answer.

[ChoiJunghoon]

thank you for your reply.