Forum Discussion

AndrewKent's avatar
AndrewKent
Icon for Helper I rankHelper 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

     

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
9 years ago

Hi Andy

 

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

EXPECTED OUTPUT

 

AndrewKent's avatar
AndrewKent
Icon for Helper I rankHelper I
9 years ago

Perfect! Exactly what I was after.