Forum Discussion
fosterXO
3 years agoFrequent Visitor
Variation % calculation based on start
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 d...
- 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
v-yanjiang-msft
Community Support
3 years agoHi 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