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

#### Community Highlights

Find out what's new in the Power BI Community!

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 188 members 1,816 guests
Recent signins: