Forum Discussion
Countif (or equivalent) Per Row in PowerQuery/Dax
Hi,
Apologies but although I can see several topics on this, I'm not sure how they fit to my specific issue. I have one table of data that I am modelling. The table contains records assessment attempts for staff. There are multiple rows for individuals. What I want to do is:
- In a new column [Attempts], carry out a countif on a column [Staff ID] for each row in the table (the Excel equivalent would be =COUNTIF([STAFF ID],A1) for each row.
- Remove duplicate rows in [Staff ID]
This should leave me with 1 record per staff member with an aggregated amount of of attempts in the [Attempts] column
Hope this makes sense.
Andy
Hi Andy
Doing a Groupby can solve your problem. See the attached screenshot.GROUPBY
EXPECTED OUTPUT
7 Replies
I think You can fit Conditional column and Groupby in this scenario.
Sample data would give me a kick start to work with your problem.
Hi,
The data set really is as simple as the first data set is the original data, and using Power Query I want to model it to look like the second table if that makes sense.
Andy
Hi Andy
Doing a Groupby can solve your problem. See the attached screenshot.GROUPBY
EXPECTED OUTPUT
