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 |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
67 | |
62 | |
55 |