Forum Discussion

derickyy's avatar
derickyy
Frequent Visitor
4 years ago
Solved

Group Two Columns with Two Different Logic

Hi,   Can you please help me with the following table manipulation? It would be best if it can be achieved through power query but dax query is also acceptable.   Basically, I have one table with...
  • HotChilli's avatar
    4 years ago

    Use the 'Group By' in Power Query.

    You can add 2 aggregations by selecting the 'Advanced' radio button.

    So 'Group By' the Person and add the 2 aggregations.

    I'll help if you get stuck