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!