cancel
Showing results for
Did you mean:
Frequent Visitor

## DAX - find difference from first and last

Hi, I have data structured like this

What I'm trying to do is get an output row like this:

id         Trend

324       .5

This takes the first score and last score from an ID, filtered by time, and finds the difference. How can I do this in DAX? I've been trying to a while and can't seem to figure it out. Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team

## Re: DAX - find difference from first and last

you can write your measure like so:

Trend =
LOOKUPVALUE (
'Table'[Score],
'Table'[Time], CALCULATE ( MAX ( 'Table'[Time] ), ALLEXCEPT ( 'Table', 'Table'[id] ) )
)
- LOOKUPVALUE (
'Table'[Score],
'Table'[Time], CALCULATE ( MIN ( 'Table'[Time] ), ALLEXCEPT ( 'Table', 'Table'[id] ) )
)

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Community Support Team

## Re: DAX - find difference from first and last

you can write your measure like so:

Trend =
LOOKUPVALUE (
'Table'[Score],
'Table'[Time], CALCULATE ( MAX ( 'Table'[Time] ), ALLEXCEPT ( 'Table', 'Table'[id] ) )
)
- LOOKUPVALUE (
'Table'[Score],
'Table'[Time], CALCULATE ( MIN ( 'Table'[Time] ), ALLEXCEPT ( 'Table', 'Table'[id] ) )
)

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 274 members 3,082 guests
Recent signins: