locked
Trouble with value RRS feed

  • Question

  • Hello. Can someone help me with the Value function? What is it doing in the formula below? 

    SUMX(

        Values(Products[Productkey])

           [ProductPrice]*[Food]

    )

    Thursday, September 1, 2016 6:46 PM

Answers

  • VALUES returns a table containing the distinct values of the column in the argument, in the current context. In your formula, you iterate over this table, calculate [ProductPrice]*[Food] for each row (=each product key), and sum the results.
    Friday, September 2, 2016 10:53 AM
    Answerer