Forum Discussion

chris_steins's avatar
chris_steins
New Member
5 years ago
Solved

DAX Formula

I'm looking to lookup a value in a data table and make a calculation based on it. Below is my example table, where I'm trying to calculate the "percent Change" column where I want to look up in the ...
Dax Help
  • AlB's avatar
    AlB
    5 years ago

    chris_steins 

    percent Change = 
VAR num_ = Table1[Value]
VAR denom_ =
    CALCULATE (
        AVERAGE ( Table1[Value] ),
        ALLEXCEPT ( Table1, Table1[Location] ),
        Table1[Rate] = 0
    )
RETURN
      DIVIDE ( num_, denom_ )

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

  • AlB's avatar
    AlB
    5 years ago

    chris_steins 

    See it all at work in the attached file.

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

     

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

     

    Cheers 

     

chris_steins's avatar
chris_steins
New Member
5 years ago

One more caveat to the question, the data table will have more than 1 entry with the same Person, Rate, and Location so I want to average the "Values" to use in the equation.