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!