Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Group Columns with CountIf

Hello everyone, Is there a way we can group multiple columns and then enforce a COUNTIFS function?   I have multiple columns that I would like to group them into one single column, and t...
Need Help
Show and Tell
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    You could unpivot these columns as a single column in query editor.

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

You could unpivot these columns as a single column in query editor.