Download the file below. Try and write the following measures.

The bonus questions are trickier, so don't worry if you can't get these ones just yet.

You will notice that you cannot edit the Power Query, so you must do everything in DAX!

Easy

·        Write a measure named Sum of Retail Price to show total (sum) sales

·        Write a measure named Sum Of Quantity to show total (sum) quantity

·        Write a measure named Average North Inventory to show average inventory for the North region

Hard

·        Write a measure named Total Retail Price to show total retail price (Retail price times quantity)

·        Write a measure named Total Price Paid to show price paid (total retail price minus discount). Note that discount is a percentage discount.

·        Write a measure named Total Retail Price to show a running total of Total Price Paid by start of month. (HINT – use a quick measure!)

·        Write a measure named Total South to show average inventory for the South region, in august and September

Bonus

·        Write a measure named Count of high customers to show how the count of customers who have bought over 15 products in total

·        Write a measure named High inventory sales to show total quantity sold, where the store has over 100 inventory in October