Help with a table transformation

Hi julianst24,

Please make a little bit change to the earlier formula.

final table =
SUMMARIZE (
    Data,
    Data[serial],
    "RANKING1", MAX ( Data[RANKING1] ),
    "RANKING2", MAX ( Data[RANKING2] ),
    "RANKING3", MAX ( Data[RANKING3] ),
    "START DATE RANKING1", MAX ( Data[START DATE RANK1] ),
    "START DATE RANKING2", MAX ( Data[START DATE RANK2] ),
    "START DATE RANKING3", MAX ( Data[START DATE RANK3] ),
    "END DATE RANKING1", MAX ( Data[END DATE RANK1] ),
    "END DATE RANKING2", MAX ( Data[END DATE RANK2] ),
    "END DATE RANKING3", MAX ( Data[END DATE RANK3] )
)

Then, the Calculated Table will look like this.

Also, attach the sample pbix as reference.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun