Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 Sales is a DAX complex measure.
Does anyone know how to do that?
*If other date is selected, the measure should change.
Thanks!
Solved! Go to Solution.
@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
@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
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |