Create New Table with Dax

[ChoiJunghoon]

Hello  

I want to create the result table with Dax. 
Could you help me ? 
TableA

Catergory	Value
A	5
B	8
C	12

TableB

Catergory	Charge
A	2
B	3
C	4

ResultTable

Category	Number
A	6
A	7
B	9
B	10
B	11
C	13
C	14
C	15
C	16

[daxer-almighty]

Another way would be:

SELECTCOLUMNS(
    GENERATE(
        NATURALINNERJOIN(
            TableA,
            TableB
        ),
        var Val = TableA[Value]
        var Cat = TableA[Category]
        var Chrg = TableB[Charge]
        var Nums = 
            SELECTCOLUMNS(
                GENERATESERIES(
                    Val + 1, 
                    Val + Chrg,
                    1
                ),
                "@Number", [Value]
            )
        return
            Nums
    ),
    "Category", TableA[Category],
    "Number", [@Number]
)

[daxer-almighty · Accepted solution]

SELECTCOLUMNS(
    GENERATE(
        TableA,
        var Val = TableA[Value]
        var Cat = TableA[Category]
        var Chrg = 
            LOOKUPVALUE(
                TableB[Charge],
                TableB[Category], Cat,
                BLANK()
            )
        var Nums = 
            SELECTCOLUMNS(
                GENERATESERIES(
                    Val + 1, 
                    Val + Chrg,
                    1
                ),
                "@Number", [Value]
            )
        return
            Nums
    ),
    "Category", TableA[Category],
    "Number", [@Number]
)

[ChoiJunghoon]

Thank you So much!!