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

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
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

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

    Thanks a bunch, much appreciated!