Notifications
Clear all
Topic starter
08/08/2022 4:37 pm
Your company has employees in 10 states.
The company recently decided to associate each state to one of the following three regions: East, West, and North.
You have a data model that contains employee information by state. The model does NOT include region
information.
You have a report that shows the employees by state.
You need to view the employees by region as quickly as possible.
What should you do?
- A . Create a new aggregation that summarizes by employee.
- B . Create a new group on the state column and set the Group type to List.
- C . Create a new group on the state column and set the Group type to Bin.
- D . Create a new aggregation that summarizes by state.
Suggested Answer: B
Explanation:
https://www.mssqltips.com/sqlservertip/4720/binning-and-grouping-data-with-power-bi/
Explanation:
https://www.mssqltips.com/sqlservertip/4720/binning-and-grouping-data-with-power-bi/