I need to calculate the growth or decrease based on the first and last record

[snaydeck]

I need to calculate the growth or decrease based on the first and last record.

I have no idea. Bring data from one column based on another. When I say this, it is because I understand that I should bring the "QTY" column based on MIN (vdata) and MAX (vdata) and this I am not able to do with the little knowledge I have.

name	vdata	qty
name a	01/01/2017	10
name a	10/10/2017	15
name a	11/11/2017	20
name b	02/02/2017	10
name b	04/04/2017	14
name b	05/05/2017	8
name c	08/08/2017	10
name c	09/09/2017	32
name c	05/05/2017	42

----------------------------------

Example "Name A":

First reading: 01/01/2017
Value: 10

Last reading: 11/11/2017
Value: 20

-> Positive Result: 100%

----------------------------------

Example "Name B"

First reading: 02/02/2017
Value: 10

Last reading: 11/11/2017
Value: 8

-> Negative Result: (- 20%)

----------------------------------

In the past I simply calculated using MIN (qty) and MAX (qty). But sometimes between falls and uploads the data comes in incorrectly. GROWPERCENT = ((MAX(qty) - MIN(qty))/ MIN(qty)

I appreciate the help.

[Zubair_Muhammad · Accepted solution]

Hi,

Use this measure

Growth :=
CALCULATE (
    VALUES ( Table1[qty] ),
    FILTER ( Table1, Table1[vdata] = MAX ( Table1[vdata] ) )
)
    / CALCULATE (
        VALUES ( Table1[qty] ),
        FILTER ( Table1, Table1[vdata] = MIN ( Table1[vdata] ) )
    )
    - 1

[snaydeck]

Hi @Zubair_Muhammad thanks a lot.

I just tested and it worked perfectly!!

When the person has the knowledge, everything is easier, right?

Thank you very much.