I need to group data by version.

[Anonymous]

Hi Experts,

I need to group data below in screen shot.  i have two columns  application and version columns in table. 

here one applictaions have many versions and one version have many devices listed.  I need output like application, version and  Devices total count.

application ID	version	count
commicrosoft.office.outlookIOS	4.3.1 (2915218)	1000
commicrosoft.office.outlookIOS	4.2125.0 (9055108)	150
commicrosoft.office.outlookAndroid	4.0.53	3000
commicrosoft.office.outlookAndroid	3.0.55	500

Here there are multiple versions and one versions have multiple devices connected. I need the count of devices for each version.

[Anonymous]

I have data in below table need to be grouped. I have different application with versions data is storing.

here one applications have different verions and one version can connect with many devices like andriod or IOS.

i need outputlike below.

Application ID	application versions	devicescount
com.microsoft.office.<outlook>IOS	4.57.2 (6028906)	100
com.microsoft.office<outlook>IOS	4.1.1 (2819328)	2000
com.microsoft.office.word.<IOS>	2.30.1 (2.30.19101703)	130
com.microsoft.office.word.<IOS>	2.26 (2.26.19060403)	180

I need the total devcies connected to each version of the application. I need to show the data in pie chart.

[v-jayw-msft]

Hi @Anonymous ,

Please check the group by feature in Power Query Editor.

Best Regards,

Jay

[MFelix]

Hi @Anonymous ,

This can be done in the frontend or in the query editor.

If you use the query editor you need to group by and then make the values grouping by the aplicationID and version and on the grouping do a count of rows.

If you are using a visualization you just need to add a measure similar to this:

Count = COUNT ( Table[applicationID])

and then add the columns you need for detail and the measure for the result.