Variation % calculation based on start

[fosterXO]

Hi,

I have the following three columns:

Date	Price 1	Price 2
01-01-2020	2	1
01-02-2020	3	1
01-03-2020	6	2
01-04-2020	12	1

I would like to have a line graph that displays the % variation from the start date, which I will decide based on a parameter. I want to have something like this:

At the beginning of the graph all the series are 0% and over time they develop: If I select to start from march price 1 wil do 0% -- 100% and price 2 0% -- -50%.

How can I build this measure?

[v-yanjiang-msft · Accepted solution]

Hi @fosterXO ,

According to your description, here's my solution.

Create two measures.

Price1 Measure =
VAR _Start =
    MAXX (
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Date] = MINX ( ALLSELECTED ( 'Table'[Date] ), 'Table'[Date] )
        ),
        'Table'[Price 1]
    )
RETURN
    DIVIDE ( MAX ( 'Table'[Price 1] ) - _Start, _Start )

Price2 Measure =
VAR _Start =
    MAXX (
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Date] = MINX ( ALLSELECTED ( 'Table'[Date] ), 'Table'[Date] )
        ),
        'Table'[Price 2]
    )
RETURN
    DIVIDE ( MAX ( 'Table'[Price 2] ) - _Start, _Start )

Get the correct result:

I attach the file below for your reference.

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Best regards,

Community Support Team_yanjiang