Power-BI-DAX-Data-Set.xlsx

	A	B	C	D	E	F	G	H	I	J
1	Retailer	Retailer ID	Date	Region	State	Beverage Brand	Price per Unit	Units Sold	Revenue	Expenses
2	Sodapop	1185732	14/1/2022	Northeast	New York	Coca-Cola	$0.50	12,000	$6,000	$1,260
3	Sodapop	1185732	14/1/2022	Northeast	New York	Diet Coke	$0.50	10,000	$5,000	$1,700
4	Sodapop	1185732	14/1/2022	Northeast	New York	Sprite	$0.40	10,000	$4,000	$480
5	Sodapop	1185732	14/1/2022	Northeast	New York	Fanta	$0.45	8,500	$3,825	$497
6	Sodapop	1185732	14/1/2022	Northeast	New York	Powerade	$0.60	9,000	$5,400	$918
7	Sodapop	1185732	14/1/2022	Northeast	New York	Dasani Water	$0.50	10,000	$5,000	$1,050
8	Sodapop	1185732	12/2/2022	Northeast	New York	Coca-Cola	$0.50	12,500	$6,250	$875
9	Sodapop	1185732	12/2/2022	Northeast	New York	Diet Coke	$0.50	9,000	$4,500	$225
10	Sodapop	1185732	12/2/2022	Northeast	New York	Sprite	$0.40	9,500	$3,800	$304
11	Sodapop	1185732	12/2/2022	Northeast	New York	Fanta	$0.45	8,250	$3,713	$408
12	Sodapop	1185732	12/2/2022	Northeast	New York	Powerade	$0.60	9,000	$5,400	$810
13	Sodapop	1185732	12/2/2022	Northeast	New York	Dasani Water	$0.50	10,000	$5,000	$1,700
14	Sodapop	1185732	10/3/2022	Northeast	New York	Coca-Cola	$0.50	12,200	$6,100	$2,074
15	Sodapop	1185732	10/3/2022	Northeast	New York	Diet Coke	$0.50	9,250	$4,625	$1,573
16	Sodapop	1185732	10/3/2022	Northeast	New York	Sprite	$0.40	9,500	$3,800	$1,862
17	Sodapop	1185732	10/3/2022	Northeast	New York	Fanta	$0.45	8,000	$3,600	$504
18	Sodapop	1185732	10/3/2022	Northeast	New York	Powerade	$0.60	8,500	$5,100	$714
19	Sodapop	1185732	10/3/2022	Northeast	New York	Dasani Water	$0.50	9,500	$4,750	$713
20	Sodapop	1185732	11/4/2022	Northeast	New York	Coca-Cola	$0.50	12,000	$6,000	$1,440
21	Sodapop	1185732	11/4/2022	Northeast	New York	Diet Coke	$0.50	9,000	$4,500	$855
22	Sodapop	1185732	11/4/2022	Northeast	New York	Sprite	$0.40	9,000	$3,600	$1,656
23	Sodapop	1185732	11/4/2022	Northeast	New York	Fanta	$0.45	8,250	$3,713	$483
24	Sodapop	1185732	11/4/2022	Northeast	New York	Powerade	$0.60	8,250	$4,950	$1,040
25	Sodapop	1185732	11/4/2022	Northeast	New York	Dasani Water	$0.50	9,500	$4,750	$1,948
26	Sodapop	1185732	10/5/2022	Northeast	New York	Coca-Cola	$0.60	12,200	$7,320	$1,318
27	Sodapop	1185732	10/5/2022	Northeast	New York	Diet Coke	$0.55	9,250	$5,088	$407
28	Sodapop	1185732	10/5/2022	Northeast	New York	Sprite	$0.50	9,000	$4,500	$1,710
29	Sodapop	1185732	10/5/2022	Northeast	New York	Fanta	$0.50	8,500	$4,250	$893
30	Sodapop	1185732	10/5/2022	Northeast	New York	Powerade	$0.60	8,750	$5,250	$1,785
31	Sodapop	1185732	10/5/2022	Northeast	New York	Dasani Water	$0.65	10,000	$6,500	$780
32	Sodapop	1185732	12/6/2022	Northeast	New York	Coca-Cola	$0.60	12,500	$7,500	$975
33	Sodapop	1185732	12/6/2022	Northeast	New York	Diet Coke	$0.55	10,000	$5,500	$935
34	Sodapop	1185732	12/6/2022	Northeast	New York	Sprite	$0.50	9,250	$4,625	$971
35	Sodapop	1185732	12/6/2022	Northeast	New York	Fanta	$0.50	9,000	$4,500	$630
36	Sodapop	1185732	12/6/2022	Northeast	New York	Powerade	$0.60	9,000	$5,400	$270
37	Sodapop	1185732	12/6/2022	Northeast	New York	Dasani Water	$0.65	10,500	$6,825	$546
38	Sodapop	1185732	10/7/2022	Northeast	New York	Coca-Cola	$0.60	12,750	$7,650	$842
39	Sodapop	1185732	10/7/2022	Northeast	New York	Diet Coke	$0.55	10,250	$5,638	$846
40	Sodapop	1185732	10/7/2022	Northeast	New York	Sprite	$0.50	9,500	$4,750	$1,615
41	Sodapop	1185732	10/7/2022	Northeast	New York	Fanta	$0.50	9,000	$4,500	$1,530
42	Sodapop	1185732	10/7/2022	Northeast	New York	Powerade	$0.60	9,250	$5,550	$1,887
43	Sodapop	1185732	10/7/2022	Northeast	New York	Dasani Water	$0.65	11,000	$7,150	$3,504
44	Sodapop	1185732	11/8/2022	Northeast	New York	Coca-Cola	$0.60	12,500	$7,500	$1,050
45	Sodapop	1185732	11/8/2022	Northeast	New York	Diet Coke	$0.55	10,250	$5,638	$789
46	Sodapop	1185732	11/8/2022	Northeast	New York	Sprite	$0.50	9,500	$4,750	$713
47	Sodapop	1185732	11/8/2022	Northeast	New York	Fanta	$0.50	9,250	$4,625	$1,110
48	Sodapop	1185732	11/8/2022	Northeast	New York	Powerade	$0.60	9,000	$5,400	$1,026
49	Sodapop	1185732	11/8/2022	Northeast	New York	Dasani Water	$0.65	10,750	$6,988	$3,214
50	Sodapop	1185732	10/9/2022	Northeast	New York	Coca-Cola	$0.60	12,000	$7,200	$936
51	Sodapop	1185732	10/9/2022	Northeast	New York	Diet Coke	$0.55	10,000	$5,500	$1,155
52	Sodapop	1185732	10/9/2022	Northeast	New York	Sprite	$0.50	9,250	$4,625	$1,896
53	Sodapop	1185732	10/9/2022	Northeast	New York	Fanta	$0.50	9,000	$4,500	$810
54	Sodapop	1185732	10/9/2022	Northeast	New York	Powerade	$0.60	9,000	$5,400	$432
55	Sodapop	1185732	10/9/2022	Northeast	New York	Dasani Water	$0.65	10,000	$6,500	$1,365
56	Sodapop	1185732	12/10/2022	Northeast	New York	Coca-Cola	$0.65	11,750	$7,638	$2,597
57	Sodapop	1185732	12/10/2022	Northeast	New York	Diet Coke	$0.55	10,000	$5,500	$660
58	Sodapop	1185732	12/10/2022	Northeast	New York	Sprite	$0.55	9,000	$4,950	$644
59	Sodapop	1185732	12/10/2022	Northeast	New York	Fanta	$0.55	8,750	$4,813	$818
60	Sodapop	1185732	12/10/2022	Northeast	New York	Powerade	$0.65	8,750	$5,688	$1,194
61	Sodapop	1185732	12/10/2022	Northeast	New York	Dasani Water	$0.70	10,000	$7,000	$980
62	Sodapop	1185732	11/11/2022	Northeast	New York	Coca-Cola	$0.65	11,500	$7,475	$374
63	Sodapop	1185732	11/11/2022	Northeast	New York	Diet Coke	$0.55	9,750	$5,363	$429
64	Sodapop	1185732	11/11/2022	Northeast	New York	Sprite	$0.55	9,200	$5,060	$557
65	Sodapop	1185732	11/11/2022	Northeast	New York	Fanta	$0.55	9,000	$4,950	$743
66	Sodapop	1185732	11/11/2022	Northeast	New York	Powerade	$0.65	8,750	$5,688	$1,934
67	Sodapop	1185732	11/11/2022	Northeast	New York	Dasani Water	$0.70	9,750	$6,825	$2,321
68	Sodapop	1185732	10/12/2022	Northeast	New York	Coca-Cola	$0.65	12,000	$7,800	$2,652
69	Sodapop	1185732	10/12/2022	Northeast	New York	Diet Coke	$0.55	10,000	$5,500	$2,695
70	Sodapop	1185732	10/12/2022	Northeast	New York	Sprite	$0.55	9,500	$5,225	$732
71	Sodapop	1185732	10/12/2022	Northeast	New York	Fanta	$0.55	9,000	$4,950	$693
72	Sodapop	1185732	10/12/2022	Northeast	New York	Powerade	$0.65	9,000	$5,850	$878
73	Sodapop	1185732	10/12/2022	Northeast	New York	Dasani Water	$0.70	10,000	$7,000	$1,680
74	BevCo	1197831	2/1/2022	South	Texas	Coca-Cola	$0.25	9,000	$2,250	$428
75	BevCo	1197831	2/1/2022	South	Texas	Diet Coke	$0.35	9,000	$3,150	$1,449
76	BevCo	1197831	2/1/2022	South	Texas	Sprite	$0.35	7,000	$2,450	$319
77	BevCo	1197831	2/1/2022	South	Texas	Fanta	$0.35	7,000	$2,450	$515
78	BevCo	1197831	2/1/2022	South	Texas	Powerade	$0.40	5,500	$2,200	$902
79	BevCo	1197831	2/1/2022	South	Texas	Dasani Water	$0.35	7,000	$2,450	$441
80	BevCo	1197831	1/2/2022	South	Texas	Coca-Cola	$0.25	8,500	$2,125	$170
81	BevCo	1197831	1/2/2022	South	Texas	Diet Coke	$0.35	8,500	$2,975	$625
82	BevCo	1197831	1/2/2022	South	Texas	Sprite	$0.35	6,750	$2,363	$803
83	BevCo	1197831	1/2/2022	South	Texas	Fanta	$0.35	6,250	$2,188	$263
84	BevCo	1197831	1/2/2022	South	Texas	Powerade	$0.40	5,000	$2,000	$260
85	BevCo	1197831	1/2/2022	South	Texas	Dasani Water	$0.35	7,000	$2,450	$417
86	BevCo	1197831	3/3/2022	South	Texas	Coca-Cola	$0.30	8,750	$2,625	$551
87	BevCo	1197831	3/3/2022	South	Texas	Diet Coke	$0.40	8,750	$3,500	$490
88	BevCo	1197831	3/3/2022	South	Texas	Sprite	$0.35	7,000	$2,450	$123
89	BevCo	1197831	3/3/2022	South	Texas	Fanta	$0.40	6,000	$2,400	$192
90	BevCo	1197831	3/3/2022	South	Texas	Powerade	$0.45	5,000	$2,250	$248
91	BevCo	1197831	3/3/2022	South	Texas	Dasani Water	$0.40	6,500	$2,600	$390
92	BevCo	1197831	2/4/2022	South	Texas	Coca-Cola	$0.30	9,000	$2,700	$918
93	BevCo	1197831	2/4/2022	South	Texas	Diet Coke	$0.40	9,000	$3,600	$1,224
94	BevCo	1197831	2/4/2022	South	Texas	Sprite	$0.35	7,250	$2,538	$863
95	BevCo	1197831	2/4/2022	South	Texas	Fanta	$0.40	6,250	$2,500	$1,225
96	BevCo	1197831	2/4/2022	South	Texas	Powerade	$0.45	5,250	$2,363	$331
97	BevCo	1197831	2/4/2022	South	Texas	Dasani Water	$0.40	8,000	$3,200	$448
98	BevCo	1197831	2/5/2022	South	Texas	Coca-Cola	$0.30	9,250	$2,775	$416
99	BevCo	1197831	2/5/2022	South	Texas	Diet Coke	$0.40	9,250	$3,700	$888
100	BevCo	1197831	2/5/2022	South	Texas	Sprite	$0.35	7,750	$2,713	$515