Scribd
Upload
30 views2 pages

4 +Introduction+to+Power+Query+in+Excel

The document provides sales data for various products sold across different locations, detailing product IDs, names, categories, prices, quantities sold, and dates. It also includes store locations, customer IDs, payment methods, discounts applied, and total sales amounts. Overall, it summarizes sales performance for a range of products in September 2023.

Uploaded by

lopvatlytuyen
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
30 views2 pages

4 +Introduction+to+Power+Query+in+Excel

The document provides sales data for various products sold across different locations, detailing product IDs, names, categories, prices, quantities sold, and dates. It also includes store locations, customer IDs, payment methods, discounts applied, and total sales amounts. Overall, it summarizes sales performance for a range of products in September 2023.

Uploaded by

lopvatlytuyen
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Product ID Product Name Category Price Quantity Sold Date Sold

101 Laptop Electronics 800 5 9/1/2023


102 T-Shirt Clothing 20 10 9/2/2023
103 Milk Groceries 2.5 20 9/3/2023
104 Smartphone Electronics 600 3 9/4/2023
105 Jeans Clothing 50 8 9/5/2023
106 Bread Groceries 1.5 15 9/6/2023
107 Headphones Electronics 30 4 9/7/2023
108 Jacket Clothing 80 6 9/8/2023
109 Cereal Groceries 3 12 9/9/2023
110 Tablet Electronics 400 2 9/10/2023
Store Location Customer ID Payment Method Discount Applied Total Sales
New York 1001 Credit Card 50 3950
Los Angeles 1002 Cash 0 200
Chicago 1003 Credit Card 2 48
Houston 1004 Debit Card 30 1770
Miami 1005 Credit Card 10 390
San Francisco 1006 Credit Card 0.5 21
Boston 1007 Credit Card 5 115
Washington, DC 1008 Cash 0 480
Seattle 1009 Debit Card 0.25 34.5
Atlanta 1010 Credit Card 20 760

You might also like