summarize table and add new columns

hi, Anonymous

Your expected output is a bit messy, and if I understand you correctly, you could try this way as below:

First add a current status column

In Edit Queries, Duplicate the basic table use Group by and merge function like this post.

https://community.powerbi.com/t5/Desktop/Findin-MAX-from-multiple-columns-in-query-editor/td-p/363299

Second use Pivot column function like below:

Select Status column and then click Transform->Pivot column

Result:

and here is pbix file, please try it.

By the way, you could change another browser eg. IE, It will be well.

Best Regards,

Lin