Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey all;
I'm trying to create a real time DSI and having difficulty on the last 90 days measure.
Here is my measure below, and it "passes" however I get the following error.
is there another "dates" DAX variable I should be using to get my last 90 days of sales?
Solved! Go to Solution.
Thanks to GPT :)... got it to work. For FYI:
this pulls passes, and does not error.
Thanks to GPT :)... got it to work. For FYI:
this pulls passes, and does not error.
@Gumberculeez , if you need based on today
Last 90 =
var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today())
var _min = _max -90
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))
or
Last 90 =
var _max = today()
var _min = _max -90
return
CALCULATE([net] ,DATESBETWEEN('Date'[Date],_min,_max))
or
Last 90 =
var _max = today()
var _min = _max -90
return
CALCULATE([net] ,filter('Date','Date'[Date]>= _min && 'Date'[Date] <= _max))
Both of those generate the same error.
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |