Forum Discussion

etalon's avatar
etalon
Frequent Visitor
7 years ago
Solved

Alternative to LOOKUPVALUE

I have got this to work, but I really don't like how I have done it, and was wondering if there was a better way?   I have two tables:   TankID: contains the unique tank ID plus related informat...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, etalon 

    For your requirement, you could try this formula:

    Column 2 = var _maxdatetime=CALCULATE(MAX(FuelLevels[Date/Time])) return
CALCULATE(SUM(FuelLevels[Value]),FuelLevels[Date/Time]=_maxdatetime)

     

    Best Regards,

    Lin

     

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, etalon 

For your requirement, you could try this formula:

Column 2 = var _maxdatetime=CALCULATE(MAX(FuelLevels[Date/Time])) return
CALCULATE(SUM(FuelLevels[Value]),FuelLevels[Date/Time]=_maxdatetime)

 

Best Regards,

Lin