Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Iterate through all my dataset to select values

Hi guys!   I'm looking forward to create a dashboard with data from ServiceNow. I am extracting around 130 MB, around 30k rows and 180 columns, this information is about incidents, CSV file. The ...
  • v-zhenbw-msft's avatar
    5 years ago

    Hi Anonymous ,

     

    You can use the GROUP BY function in Power Query. Please refer the following screenshot.

     

     

    If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.