Add summarizing column and reference column

Hi Nipius '

I create a new table

Table 3 =
UNION (
    SUMMARIZE (
        Sheet4,
        Sheet4[year/month],
        Sheet4[group],
        Sheet4[value],
        Sheet4[w]
    ),
    SELECTCOLUMNS (
        SUMMARIZE (
            ADDCOLUMNS (
                Sheet4,
                "number", VALUE ( RIGHT ( [w], 1 ) ),
                "2+", CALCULATE (
                    SUM ( Sheet4[value] ),
                    FILTER (
                        ALLEXCEPT ( Sheet4, Sheet4[year/month], Sheet4[group] ),
                        VALUE ( RIGHT ( [w], 1 ) ) >= 2
                    )
                ),
                "w+", "2+"
            ),
            Sheet4[year/month],
            Sheet4[group],
            [2+],
            [w+]
        ),
        "year/month", [year/month],
        "group", [group],
        "value", [2+],
        "w", [w+]
    )
)

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.