Forum Discussion

Anonymous's avatar
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's avatar
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's avatar
    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