Calculate Columns

  • 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!