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!
<tbody>
</tbody>
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!
UPC | Store | Bucket | Package | Time | Dollars | MIN TIME | SUM ON UPC | ANNUALIZE |
108372 | 201313 | DWF | MSC | 5 | $308 | 5 | $308 | $445 |
108372 | 203320 | DWF | MSC | 1 | $35 | 1 | $143 | $143 |
108372 | 203320 | DWF | MSC | 3 | $24 | 1 | $143 | $143 |
108372 | 203320 | DWF | MSC | 4 | $48 | 1 | $143 | $143 |
108372 | 203320 | DWF | MSC | 5 | $36 | 1 | $143 | $143 |
108372 | 203330 | DWF | MSC | 3 | $12 | 3 | $36 | $43 |
108372 | 203330 | DWF | MSC | 6 | $12 | 3 | $36 | $43 |
108372 | 203330 | DWF | MSC | 10 | $12 | 3 | $36 | $43 |
100300 | 203330 | DWF | MSC | 12 | $12 | 12 | $12 | $78 |
100300 | 203361 | DWF | MSC | 1 | $49 | 1 | $86 | $86 |
100300 | 203361 | DWF | MSC | 2 | $25 | 1 | $86 | $86 |
100300 | 203361 | DWF | MSC | 4 | $12 | 1 | $86 | $86 |
100300 | 203363 | DWF | MSC | 1 | $26 | 1 | $354 | $354 |
100300 | 203363 | DWF | MSC | 2 | $50 | 1 | $354 | $354 |
100300 | 203363 | DWF | MSC | 3 | $12 | 1 | $354 | $354 |
100300 | 203363 | DWF | MSC | 4 | $60 | 1 | $354 | $354 |
100300 | 203363 | DWF | MSC | 5 | $12 | 1 | $354 | $354 |
100300 | 203363 | DWF | MSC | 6 | $12 | 1 | $354 | $354 |
100300 | 203363 | DWF | MSC | 7 | $61 | 1 | $354 | $354 |
100300 | 203363 | DWF | MSC | 8 | $24 | 1 | $354 | $354 |
100300 | 203363 | DWF | MSC | 10 | $24 | 1 | $354 | $354 |
100300 | 203363 | DWF | MSC | 11 | $24 | 1 | $354 | $354 |
100300 | 203363 | DWF | MSC | 12 | $37 | 1 | $354 | $354 |
100300 | 203363 | DWF | MSC | 13 | $12 | 1 | $354 | $354 |
100300 | 203375 | DWF | MSC | 2 | $12 | 2 | $98 | $106 |
100300 | 203375 | DWF | MSC | 4 | $12 | 2 | $98 | $106 |
100300 | 203375 | DWF | MSC | 6 | $24 | 2 | $98 | $106 |
100300 | 203375 | DWF | MSC | 8 | $25 | 2 | $98 | $106 |
100300 | 203375 | DWF | MSC | 10 | $25 | 2 | $98 | $106 |
<tbody>
</tbody>