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.
Relative date filtering works for showing values within a time period (i.e. "Last 90 days", Last Year") However, is it possible to filter values outside of a selected time period? For example, I have a work order database. I would like to display all work orders older than 90 days. How could I accomplish this? I am using Direct Query mode so creating a custom is presumably out of the question.
Solved! Go to Solution.
Hi @JDTAYLOR
You might try this measure:
Outoflast90days=
var a = SELECTEDVALUE('Table 2'[Date])
Return
IF(MAX('Table'[Date])>=a-90&&MAX('Table'[Date])<=a,0,1)
table2 is a calendar table, filter the measure with 1, and then you can get the results.
Hi @JDTAYLOR
You might try this measure:
Outoflast90days=
var a = SELECTEDVALUE('Table 2'[Date])
Return
IF(MAX('Table'[Date])>=a-90&&MAX('Table'[Date])<=a,0,1)
table2 is a calendar table, filter the measure with 1, and then you can get the results.
@JDTAYLOR ,Assuming date in slicer is from the date table. Try a measure like
Measure =
var _min = minx(date,date[date])
return
calculate([Measure2],filter(all(date),date[date]<=_min))
Thank you for the quick response @amitchandak! What is the significance of "measure2" in your formula?
Here is what I have so far.
[Measure 2] is any calculation you want to use
count(Table[ID]) or sum(Table[Value])
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |