Forum Discussion

AndrewKent's avatar
AndrewKent
Helper I
9 years ago
Solved

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 at...
Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    Hi Andy

     

    Doing a Groupby can solve your problem. See the attached screenshot.GROUPBY

    EXPECTED OUTPUT

     

AndrewKent's avatar
AndrewKent
Helper I
9 years ago

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

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

Hi Andy

 

Doing a Groupby can solve your problem. See the attached screenshot.GROUPBY

EXPECTED OUTPUT

 

  • AndrewKent's avatar
    AndrewKent
    Helper I
    9 years ago

    Perfect! Exactly what I was after.