Calculation and Formulae Help

cdave

New Member
Joined
Mar 17, 2019
Messages
1
Hello All,

I am having a bit of an issue putting together some DAX Formulae; this is something I can do in Excel but using Power Pivot and Power Query I am out of my comfort zone!

There are three columns in CAPS that I am trying to figure out in Power Pivot.

MIN TIME - this is using 'Time', 'UPC' and 'Store' and finding the minimum number
SUM ON UPC - this is finding a sum for each 'UPC' and 'Store'
ANNUALIZE - using a formula to annualize the data from the sum on UPC column (should be easy once I can calculate MIN TIME and SUM ON UPC

Thank you for the help!

UPCStoreBucketPackageTimeDollarsMIN TIMESUM ON UPCANNUALIZE
108372201313DWFMSC5$3085$308$445
108372203320DWFMSC1$351$143$143
108372203320DWFMSC3$241$143$143
108372203320DWFMSC4$481$143$143
108372203320DWFMSC5$361$143$143
108372203330DWFMSC3$123$36$43
108372203330DWFMSC6$123$36$43
108372203330DWFMSC10$123$36$43
100300203330DWFMSC12$1212$12$78
100300203361DWFMSC1$491$86$86
100300203361DWFMSC2$251$86$86
100300203361DWFMSC4$121$86$86
100300203363DWFMSC1$261$354$354
100300203363DWFMSC2$501$354$354
100300203363DWFMSC3$121$354$354
100300203363DWFMSC4$601$354$354
100300203363DWFMSC5$121$354$354
100300203363DWFMSC6$121$354$354
100300203363DWFMSC7$611$354$354
100300203363DWFMSC8$241$354$354
100300203363DWFMSC10$241$354$354
100300203363DWFMSC11$241$354$354
100300203363DWFMSC12$371$354$354
100300203363DWFMSC13$121$354$354
100300203375DWFMSC2$122$98$106
100300203375DWFMSC4$122$98$106
100300203375DWFMSC6$242$98$106
100300203375DWFMSC8$252$98$106
100300203375DWFMSC10$252$98$106

<tbody>
</tbody>
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Forum statistics

Threads
1,213,536
Messages
6,114,205
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top