Forum Discussion

yuvarajin's avatar
yuvarajin
Regular Visitor
5 years ago
Solved

How to group by using categorial values using some business logics

Dear Friends,   i am trying to achieve the results by grouping the decision of Episode ID using some business logic, can anyone help me on this?   Please refer below image for data set and expect...
Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    5 years ago

    yuvarajin -

    I attempted using Power Query.

    if Table.MatchesAllRows([Grouped], each [Decision] = "Approved") then "Approved" else if Table.MatchesAllRows([Grouped], each [Decision] = "Denied") then "Denied" else if Table.MatchesAllRows([Grouped], each [Decision] = "Partially denied") then "Partially denied" else if Table.MatchesAnyRows([Grouped], each [Decision] = "Pending") then "Pending" else "Partially denied"
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    Sorry. Try COUNTROWS ( DecisionList ) = 1 instead.

ChrisMendoza's avatar
ChrisMendoza
Icon for Resident Rockstar rankResident Rockstar
5 years ago

yuvarajin -

I attempted using Power Query.

if Table.MatchesAllRows([Grouped], each [Decision] = "Approved") then "Approved" else if Table.MatchesAllRows([Grouped], each [Decision] = "Denied") then "Denied" else if Table.MatchesAllRows([Grouped], each [Decision] = "Partially denied") then "Partially denied" else if Table.MatchesAnyRows([Grouped], each [Decision] = "Pending") then "Pending" else "Partially denied"
yuvarajin's avatar
yuvarajin
Regular Visitor
5 years ago

Thanks Chris for the quick solutioning and help. This is one of the cool technique i learned from you power query:) i appreciate your support and help on this. Have a good day!