Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 58 | |
| 45 | |
| 42 | |
| 21 | |
| 18 |
| User | Count |
|---|---|
| 172 | |
| 107 | |
| 92 | |
| 54 | |
| 46 |