cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
aogata Frequent Visitor
Frequent Visitor

re grouping data according to multiple variables

I have a dataset of room information each with multiple description fields.

For example: Building#1 | great condition |   Bathroom |  250 sqft

 

I would like to be able to create a new set of variables.  for example: total area of bathrooms in Building #2 in great condition, so I can compare that number with total area of Bathrooms in Buildnig#7 in poor condition.

 

Thoughts?

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft dkay84_PowerBI
Microsoft

Re: re grouping data according to multiple variables

You can easily do this in the query editor:

 

Create a reference table (right click on your table and select Reference)

 

Click on Group By in the ribbon

 

Select Building #, Condition and Room for grouping, sqft for aggregation set to sum

 

Done

View solution in original post

1 REPLY 1
Microsoft dkay84_PowerBI
Microsoft

Re: re grouping data according to multiple variables

You can easily do this in the query editor:

 

Create a reference table (right click on your table and select Reference)

 

Click on Group By in the ribbon

 

Select Building #, Condition and Room for grouping, sqft for aggregation set to sum

 

Done

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)