Forum Discussion

JBI's avatar
JBI
Frequent Visitor
7 years ago
Solved

Difference Between Oldest and Latest Value

Good Day,   I have a very simple problem that I can not solve. I simply want to get the difference between the most recent and the oldest value in a table (as Delta). I want to use the most recent ...
Need Help
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
7 years ago

Hi JBI 

Sorry can not see the link, but try the below if it works for you as measures.

first value = 
CALCULATE(
    SELECTEDVALUE( YourTable[Value] ),
    FIRSTDATE( YourTable[Date] )
)

 

last value = 
CALCULATE(
    SELECTEDVALUE( YourTable[Value] ),
    LASTDATE( YourTable[Date] )
)

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski



  • JBI's avatar
    JBI
    Frequent Visitor
    7 years ago

    This also works. Thanks man I appreciate