Bring Column value as header

Hi askspepsi ,

You may refer the formula below.

Table 2 =
DISTINCT (
    SELECTCOLUMNS (
        'Table',
        "Regular Hour", SUMX (
            FILTER ( 'Table', 'Table'[OT Type] = "Regular Hour" ),
            'Table'[OT in Mintues]
        ),
        "normal Hour", SUMX (
            FILTER ( 'Table', 'Table'[OT Type] = "normal hour" ),
            'Table'[OT in Mintues]
        ),
        "special Hour", SUMX (
            FILTER ( 'Table', 'Table'[OT Type] = "special hour" ),
            'Table'[OT in Mintues]
        )
    )
)

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.