Comparing Values based on two different times

[Anonymous]

HI All, 

I have a to compare some data based on the selection of the date where the data were created. 

Table: 

FC on		FC for		Value
01.05.2021		01.02.2022		100
01.06.2021		01.02.2022		99
01.06.2021		01.03.2022		150
01.07.2021		01.02.2022		105
01.07.2021		01.03.2022		85

I'm trying to compare the values in two selected "FC on"

e.g. I've selected via Slicer "FC on" 01.06.2021 and 01.07.2021

Desired result is: 

FC for		01.06.2021		01.07.2021		Delta
01.02.2022		99		105		6
01.03.2022		150		85		-65

All Data are in one table, didanybody had this problem and might share some hints or a solution to the problem? 

Thank you in advance!  

[amitchandak]

@Anonymous , You can create three measures and use

Min date =
var _max = maxx(allselected(Table),Table[FC on])
var _min = maxx(allselected(Table),Table[FC on])
return
calculate( sum(Table[Value]), filter('Table', 'Table'[FC on] =_min ))

Max date =
var _max = maxx(allselected(Table),Table[FC on])
var _min = maxx(allselected(Table),Table[FC on])
return
calculate( sum(Table[Value]), filter('Table', 'Table'[FC on] =_max ))

Diff =
divide([Max date] - [Min date], [Min date])

[Anonymous · Accepted solution]

Thank you I've adjusted it a bit and placed in in one measure 🙂 works fine! 

FC Delta = 
    VAR _MAX = MAXX(ALLSELECTED(Table),Table[FC on])
    VAR _MIN = MINX(ALLSELECTED(Table),Table[FC on])
    VAR MinDate = CALCULATE(sum(Table[Value]),FILTER(Table,Table[FC on] = _MIN))
    VAR MaxDate = CALCULATE(sum(Table[Value]),FILTER(Table,Table[FC on] = _MAX))
    VAR FCDelta = MaxDate - MinDate
    return
    FCDelta