Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Comparing Values based on two different times

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.20...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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
amitchandak's avatar
amitchandak
Super User
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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