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
  • tex628's avatar
    tex628
    7 years ago

    You should be able to calculate it with something along the lines of:

    min PLS =
VAR minDate = Calculate(MIN(claendar[{date]) , allselected(calendar))
return 
Calculate( 
sum([amount]) , 
calendar[date] = minDate
)
Mariusz's avatar
Mariusz
Community 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