F4IT.pdf

Power BI Desktop Sum of unit_price by Quarter SUM_OF_SHIP AND SUM OF QUANTITY BY ORDER ID...

Power BI Desktop Sum of unit_price by Quarter SUM_OF_SHIP AND SUM OF QUANTITY BY ORDER ID 100% order_id ship_via quantity First ship_name Sum of ship_via Sum  10643 1 2 Alfreds Futterkiste 1 10643 1 15 Alfreds Futterkiste 1 Sum of unit_price 10643 1 21 Alfreds Futterkiste 1 10692 2 20 Alfred's Futterkiste 2 50% 10702 1 6 Alfred's Futterkiste 1 Customer_id 10702 1 15 Alfred's Futterkiste 1 All  10835 3 2 Alfred's Futterkiste 3 10835 3 15 Alfred's Futterkiste 3 10952 1 2 Alfred's Futterkiste 1 0% 10952 1 16 Alfred's Futterkiste 1 Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total Alfreds Futterkiste 1666 Order_Approve_date Quarter 04-07-1996  06-05-1998  Sum of discount by Quarter Sum of ship_via by unit_price and order_date Increase Decrease Total Other 1700 Qtr 4 Sum of ship_via Qtr 1 1680 1660 2 Other 14 Janu… 21 Febr… 13 Marc… 29 Octo… 10 Janu… 2.5 18 Dece… 23 July … 29 Augu… 12 Nove… 14 Febr… Other 3.6 Other 23 July … 29 Augu… Qtr 3 Qtr 2 unit_price