Forum Discussion

DJsummers's avatar
DJsummers
Icon for Helper I rankHelper I
5 years ago
Solved

Help with a measure

I have 2 tables, which for the purposes of my question I have made very basic:   The table on the left will change each day - the day will change and the temperature will change.   The ...
Need Help
  • BA_Pete's avatar
    BA_Pete
    5 years ago

    Hi DJsummers ,

     

    You could try a measure like this, where 'aTable' is your single changing value, and 'bTable' is your target table.

    _tempDiff = 
VAR todayDay = MAX(aTable[day])
RETURN
CALCULATE(
    MAX(aTable[temp]) - MAX(bTable[temp]),
    FILTER(
        bTable,
        bTable[day] = todayDay
    )
)

     

    This gives me the following output:

     

     

    Pete

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

DJsummers , Create a new column in table 2(standard)

 

standard[temperature] - maxx(filter(changes, changes[day] = standard[day]),changes[temperature])

 

or a measure

measure =
var _max = maxx(allselected(changes), changes[day])
return
maxx(filter(standard, standard[day] =_max),standard[temperature]) - maxx(filter(changes,changes[day] =_max),changes[temperature])