14 PP - Dax Functions - Calculate

OrderID Order Date Region Category
1 11/9/2017 South Furniture

3 6/13/2017 Central Office Supplies
6 6/9/2019 West Furniture
7 6/9/2017 West Office Supplies
8 6/9/2017 West Technology
9 6/9/2017 North Office Supplies
10 6/9/2017 North Office Supplies
11 6/9/2019 North Furniture
12 6/9/2019 North Technology
Return Quantity
7
3
2
5
2
7
4
6
3
5
9
4
3
Row ID Order Date Ship Date Segment State Region
1153 1/1/2016 1/7/2016 Corporate Nevada West
2822 1/1/2016 1/6/2016 Consumer California West
4613 1/1/2016 1/7/2016 Consumer Florida South
6342 1/1/2016 1/3/2016 Consumer Ohio East
6683 1/2/2017 1/3/2016 Home Office Wisconsin Central
8070 1/2/2016 1/6/2016 Consumer Texas Central
1341 1/3/2016 1/5/2016 Corporate North Carolina South
9686 1/3/2016 1/5/2016 Corporate California West
4937 1/7/2016 1/14/2016 Home Office Alabama South
978 1/8/2016 1/11/2016 Corporate Michigan Central
2290 1/9/2016 1/12/2016 Corporate Washington West
7221 1/10/2016 1/14/2016 Consumer Pennsylvania East
1846 1/13/2016 1/18/2016 Home Office District of Columbia East
8641 1/13/2016 1/17/2016 Corporate Texas Central
6619 1/14/2016 1/19/2016 Corporate Missouri Central
1183 1/15/2016 1/16/2016 Consumer North Carolina South
4165 1/15/2016 1/17/2016 Corporate Colorado West
4910 1/15/2016 1/19/2016 Consumer Tennessee South
9859 1/15/2016 1/21/2016 Home Office Indiana Central
3954 1/16/2016 1/20/2016 Consumer Massachusetts East
5068 1/16/2016 1/20/2016 Home Office California West
6521 1/17/2016 1/19/2016 Consumer Michigan Central
9387 1/20/2016 1/24/2016 Consumer Vermont East
440 1/21/2016 1/24/2016 Corporate New York East
5425 1/21/2016 1/27/2016 Consumer Connecticut East
7408 1/21/2016 1/22/2016 Consumer Illinois Central
733 1/22/2016 1/26/2016 Home Office Washington West
1096 1/22/2016 1/27/2016 Home Office North Carolina South
2680 1/22/2016 1/28/2016 Home Office Michigan Central
516 1/23/2016 1/28/2016 Home Office Montana West
7984 1/23/2016 1/26/2016 Corporate Illinois Central
9654 1/24/2016 1/28/2016 Home Office Arizona West
2376 1/25/2016 1/31/2016 Consumer Georgia South
2834 1/27/2016 2/1/2016 Corporate Alabama South
7222 1/28/2016 2/1/2016 Consumer New York East
4784 1/29/2016 2/2/2016 Consumer Kansas Central
6778 1/29/2016 2/2/2016 Home Office New York East
9915 1/30/2016 2/1/2016 Consumer Iowa Central
771 1/31/2016 2/6/2016 Corporate Iowa Central
131 2/3/2016 2/6/2016 Corporate Ohio East
7445 2/4/2016 2/8/2016 Home Office Illinois Central
2263 2/7/2016 2/10/2016 Consumer Virginia South
2368 2/11/2016 2/14/2016 Consumer Maryland East
2730 2/14/2016 2/20/2016 Consumer Washington West
9633 2/14/2016 2/18/2016 Consumer Minnesota Central
6313 2/17/2016 2/22/2016 Corporate Connecticut East
4362 2/18/2016 2/22/2016 Consumer Louisiana South
4653 2/18/2016 2/24/2016 Home Office New Jersey East
8106 2/18/2016 2/20/2016 Home Office Texas Central
9344 2/18/2016 2/21/2016 Home Office Ohio East
1837 2/20/2016 2/22/2016 Corporate Georgia South
3286 2/21/2016 2/26/2016 Home Office Oklahoma Central
7227 2/25/2016 2/29/2016 Corporate Pennsylvania East
7638 3/2/2016 3/8/2016 Corporate Delaware East
1323 3/3/2016 3/8/2016 Consumer Kentucky South
3813 3/5/2016 3/5/2016 Consumer Wisconsin Central
5949 3/5/2016 3/5/2016 Corporate Mississippi South
1372 3/7/2016 3/12/2016 Home Office Maryland East
1254 3/10/2016 3/14/2016 Home Office Pennsylvania East
8043 3/11/2016 3/15/2016 Home Office Massachusetts East
3188 3/12/2016 3/17/2016 Corporate Massachusetts East
5387 3/12/2016 3/17/2016 Consumer Arkansas South
3065 3/13/2016 3/18/2016 Home Office New Mexico West
4459 3/13/2016 3/20/2016 Consumer Colorado West
8785 3/17/2016 3/23/2016 Home Office Tennessee South
9890 3/19/2016 3/20/2016 Corporate New Jersey East
447 3/20/2016 3/25/2016 Consumer Indiana Central
4429 3/21/2016 3/27/2016 Consumer Oklahoma Central
8377 3/21/2016 3/27/2016 Corporate Florida South
2941 3/25/2016 3/31/2016 Corporate Wisconsin Central
6130 3/26/2016 4/2/2016 Home Office Virginia South
5873 3/30/2016 4/3/2016 Home Office Georgia South
3089 3/31/2016 4/2/2016 Home Office Kentucky South
2402 4/1/2016 4/4/2016 Consumer Missouri Central
6008 4/1/2016 4/3/2016 Corporate South Carolina South
5642 4/2/2016 4/5/2016 Home Office Connecticut East
9670 4/2/2016 4/6/2016 Consumer Alabama South
8416 4/6/2016 4/12/2016 Home Office Iowa Central
8738 4/6/2016 4/10/2016 Corporate Tennessee South
232 4/7/2016 4/12/2016 Home Office Florida South
1440 4/12/2016 4/15/2016 Consumer Rhode Island East
2663 4/14/2016 4/15/2016 Home Office Missouri Central
3011 4/17/2016 4/23/2016 Home Office Colorado West
5978 4/24/2016 4/25/2016 Consumer Arizona West
6024 4/24/2016 4/27/2016 Corporate Rhode Island East
7157 4/29/2016 5/4/2016 Consumer New Jersey East
3896 5/1/2016 5/5/2016 Home Office Arkansas South
5012 5/11/2016 5/13/2016 Corporate Arizona West
2595 5/13/2016 5/17/2016 Corporate Indiana Central
8336 5/13/2016 5/18/2016 Home Office Delaware East
1245 5/14/2016 5/21/2016 Consumer Mississippi South
6459 5/14/2016 5/17/2016 Corporate Maryland East
4715 5/18/2016 5/20/2016 Consumer Oregon West
4363 5/20/2016 5/22/2016 Consumer North Dakota Central
9143 5/20/2016 5/26/2016 Consumer Nevada West
7000 5/26/2016 5/29/2016 Corporate Kentucky South
6436 5/27/2016 5/29/2016 Consumer Idaho West
86 5/28/2016 5/30/2016 Consumer South Carolina South
6242 5/28/2016 5/31/2016 Corporate New Hampshire East
3717 5/29/2016 6/2/2016 Home Office Nebraska Central
7412 5/30/2016 6/3/2016 Home Office Oregon West
7660 6/1/2016 6/5/2016 Corporate Nebraska Central
5476 6/15/2016 6/18/2016 Home Office Minnesota Central
7895 6/21/2016 6/25/2016 Home Office West Virginia East
6145 6/27/2016 7/1/2016 Consumer Nebraska Central
395 6/30/2016 7/5/2016 Home Office Nevada West
2437 7/3/2016 7/10/2016 Consumer New Mexico West
8577 7/3/2016 7/4/2016 Consumer New Hampshire East
5976 7/13/2016 7/17/2016 Corporate Kansas Central
2091 7/15/2016 7/19/2016 Consumer Delaware East
7690 7/15/2016 7/17/2016 Corporate Virginia South
2314 7/20/2016 7/25/2016 Corporate South Dakota Central
3155 7/20/2016 7/24/2016 Corporate Minnesota Central
4273 7/21/2016 7/21/2016 Consumer Utah West
2856 7/25/2016 7/31/2016 Consumer South Dakota Central
6399 8/6/2016 8/12/2016 Home Office New Hampshire East
6693 8/11/2016 8/13/2016 Home Office Louisiana South
9129 9/4/2016 9/5/2016 Corporate Oregon West
2652 9/17/2016 9/21/2016 Corporate Utah West
4428 9/22/2016 9/28/2016 Corporate New Mexico West
5152 9/25/2016 9/28/2016 Corporate Montana West
3051 10/6/2016 10/11/2016 Home Office Idaho West
9487 10/12/2016 10/12/2016 Consumer West Virginia East
9261 11/11/2016 11/14/2016 Consumer South Dakota Central
2235 12/5/2016 12/10/2016 Corporate Vermont East
7821 12/8/2016 12/10/2016 Home Office Rhode Island East
3526 12/10/2016 12/15/2016 Home Office Mississippi South
5276 12/14/2016 12/20/2016 Corporate Arkansas South
8856 12/24/2016 12/30/2016 Corporate Idaho West
7485 12/28/2016 1/2/2017 Home Office North Dakota Central
7486 12/28/2016 1/2/2017 Home Office North Dakota Central
9494 1/3/2017 1/8/2017 Corporate Oklahoma Central
804 3/13/2017 3/18/2017 Corporate Louisiana South
8799 4/7/2017 4/11/2017 Home Office Vermont East
1639 5/27/2017 6/2/2017 Consumer District of Columbia East
7473 7/2/2017 7/4/2017 Home Office Utah West
1795 9/6/2017 9/11/2017 Home Office Kansas Central
2554 9/15/2017 9/19/2017 Home Office South Carolina South
2256 9/18/2017 9/23/2017 Corporate Maine East
5870 11/8/2017 11/13/2017 Home Office Wyoming West
4736 6/13/2018 6/19/2018 Home Office Maine East
1896 12/31/2018 1/4/2017 Consumer Montana West
3028 8/24/2019 8/24/2019 Corporate Montana West
Category Sub-Category Sales Quantity Profit
Office Supplies Art 4 2 2
Office Supplies Binders 160 7 54
Technology Phones 302 3 23
Office Supplies Paper 23 5 8
Office Supplies Storage 157 4 -35
Furniture Furnishings 49 4 9
Furniture Furnishings 141 5 -187
Furniture Chairs 311 4 -27
Office Supplies Binders 6 5 -10
Office Supplies Appliances 15 2 -39
Technology Machines 696 2 -28
Furniture Tables 913 5 -170
Office Supplies Storage 372 3 28
Technology Accessories 17 1 6
Technology Machines 3060 2 680
Office Supplies Supplies 110 7 32
Office Supplies Fasteners 8 1 4
Furniture Tables 893 2 80
Office Supplies Envelopes 10 1 5
Furniture Bookcases 213 3 53
Technology Accessories 169 7 -15
Office Supplies Appliances 34 1 4
Furniture Chairs 303 3 73
Office Supplies Labels 6 2 2
Technology Phones 430 2 -93
Technology Copiers 3000 5 1380
Furniture Bookcases 89 1 -17
Office Supplies Supplies 7 4 -1
Office Supplies Fasteners 11 3 -2

14 PP - Dax Functions - Calculate

Uploaded by

Copyright:

Available Formats

14 PP - Dax Functions - Calculate

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

14 PP - Dax Functions - Calculate

Uploaded by

Copyright:

Available Formats

OrderID Order Date Region Category

1 11/9/2017 South Furniture

You might also like