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

     

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

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.

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.

  • sgoyal's avatar
    sgoyal
    New Member
    4 years ago

    hi,

     

    I am looking for countif to work same as it work in excel. so, each row would have distinct count

    I am new to power query pls help in how to add column and add function. 

    Thanks in advance