Forum Discussion

Anonymous

Not applicable

6 years ago

undefined

So I habe data like this. Date. Type Value 19/1/2020 A 12 19/1/2020 B 20 20/1/2020 A 40 20/1/2020 B 20 . . I want to calculate A - B and plot it on a graph. I can't write Type = A in a formul...

Anonymous

Not applicable

6 years ago

Yes every different type (A. B, C) have data for each date.

Expected result

Date Result

19/1/2020. -12

20/1/2020. 20

vivran22

Community Champion

6 years ago

Anonymous

You may try this:

Reuslt = 
VAR _FirstValue = 
 FIRSTNONBLANK(
    dtTable3[Value],
        MAX(dtTable3[Date])
)

VAR _LastValue = 
 LASTNONBLANK(
    dtTable3[Value],
        MAX(dtTable3[Date])
)

VAR _Difference = _FirstValue - _LastValue

RETURN
_Difference

Cheers!
Vivek

If it helps, please mark it as a solution. Kudos would be a cherry on the top 🙂
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter