Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sales difference using date slicer

Hi everyone!   I need help with a DAX measure...      I have a time slicer:  I would like to have the following measure:   Measure= (Sales on 03/06/2019) - (Sales on 10/02/2020)* Where...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous ,

    A measure like this

     

    measure =
    var _min = minx(allselected(Date), Date[Date])
    var _max = maxx(allselected(Date), Date[Date])
    return
    calculate([sales], filter(Date,Date[Date]= _min))-calculate([sales], filter(Date,Date[Date]= _max))

     

    Assumed slicer is from date table

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous ,

A measure like this

 

measure =
var _min = minx(allselected(Date), Date[Date])
var _max = maxx(allselected(Date), Date[Date])
return
calculate([sales], filter(Date,Date[Date]= _min))-calculate([sales], filter(Date,Date[Date]= _max))

 

Assumed slicer is from date table