Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
aogata
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

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.