Forum Discussion

Melodyv's avatar
Melodyv
Icon for Helper I rankHelper I
3 years ago
Solved

Group by multiple columns - no need to sum

Here is what I'm working with.  The FNPI and MIS ID are the same in two rows (MIS ID being the client ID and FNPI being the outcome the client worked toward).  This client achieved the outcome, so I ...
Need Help
  • ovde's avatar
    ovde
    3 years ago

    I think you need to do something simular to this Create Row Number for Each Group in Power BI using Power Query - RADACAD

    The key point here is that when you use table.filldown, you need to refer to the column that contains your new subtables not to the last step in the query, this will apply the function to the subtables. Next you can expand the subtables and remove any excess columns. 

    I think this should produce the results you're after.

Melodyv's avatar
Melodyv
Icon for Helper I rankHelper I
3 years ago

I am needing to keep all client results, not just those that were served and achieved, so I don't think a filter would work.  I've tried sorting by multiple columns (FNPI, MIS ID, and Achieved) and then using Fill Down, but I get incorrect results.  It fills all the way down without regard to the FNPI or MIS ID columns.  That's why I'm thinking I need to group them somehow, but I can't seem to get it figured out.

ovde's avatar
ovde
Icon for Resolver II rankResolver II
3 years ago

I think you need to do something simular to this Create Row Number for Each Group in Power BI using Power Query - RADACAD

The key point here is that when you use table.filldown, you need to refer to the column that contains your new subtables not to the last step in the query, this will apply the function to the subtables. Next you can expand the subtables and remove any excess columns. 

I think this should produce the results you're after.