Forum Discussion

fosterXO's avatar
fosterXO
Frequent Visitor
3 years ago
Solved

Variation % calculation based on start

Hi,

I have the following three columns:

DatePrice 1Price 2
01-01-202021
01-02-202031
01-03-202062
01-04-2020121


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?

Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    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

     

1 Reply

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    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