Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Everyone,
Does anyone know how to do the following:
1. Calculate the number of days between two dates, based on slicer selection. The slicer has to be the 'Between' one where you need to input two dates.
2. Then based on the number of days, perform a count of how many sales were made between and including those dates.
Because the date has to be a range, i have no idea how this works. Does 'SelectedValue' still make sense?
Thanks in advance!
Solved! Go to Solution.
@Anonymous , Try a new measure like
diff =
var _min =minx(allselected(date),date[date])
var _max =maxx(allselected(date),date[date])
return
return datediff(_min,_max,day)
@Anonymous , Try a new measure like
diff =
var _min =minx(allselected(date),date[date])
var _max =maxx(allselected(date),date[date])
return
return datediff(_min,_max,day)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |