HOTSPOT -
You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:
✑ CustomerID
✑ Customer City
✑ Customer State
✑ Customer Name
✑ Customer Address 1
✑ Customer Address 2
✑ Customer Postal Code
The Invoice table contains the following fields:
✑ Order ID
✑ Invoice ID
✑ Invoice Date
✑ Customer ID
✑ Total Amount
✑ Total Item Count
The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.
The Power BI model must provide the following information:
✑ The number of customers invoiced in each state last month
✑ The average invoice amount per customer in each postal code
You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
stokazz
Highly Voted 4 years, 1 month agoVidSicious
Highly Voted 3 years, 11 months agoSachaBLM
Most Recent 2 years, 3 months agoblumek
2 years, 3 months agoDummy92yash
2 years, 7 months agoFranz58
2 years, 10 months agoFranz58
2 years, 10 months agoken218
3 years, 10 months agocommot_check
4 years ago