A Question about Power Query

shouronpou 

You can use this query:

let
    Source = Excel.CurrentWorkbook(){[Name="Detail"]}[Content],

    // Group by Major Tasks, return a list column called Progress containing the Progress values for that major task
    Groups = Table.Group(Source, {"Major Tasks"}, {{"Progress", each _[Progress]}}),

    /* Add a column that counts the distinct Progress values for each major task
    If the count is greater than 1, return "In progress"
    Otherwise the count is 1, return the first item (they're all the same)*/
    Result = Table.AddColumn(Groups, "Status", 
                each 
                    if List.Count(
                            List.Distinct(_[Progress])
                        )>1 
                    then "In Progress" 
                    else _[Progress]{0}
            )[[Major Tasks], [Status]]
in
    Result

This will result in a summary table as shown in green: