split data automatically via dax

Hi Team,   I have two tables as  picture, 1 & 2 as the datta source . and in the right, it should be the output. how to achieve that in power bi desktop?