Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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
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
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |