Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have the following chart visual and today 3/1/23 I see this.
What do I need to do to drop March 2022, since March 2023 has shown up?
Solved! Go to Solution.
I am still confused with this. What is [Net]? I am using my Date Column for [Date]
YTD Today =
var _min = eomonth(today(),-12)+1
var _max = today()
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))
@bdehning , You can use a relative date filter or slicer to show last 12 month
or can have measure like
YTD Today =
var _min = eomonth(today(),-12)+1
var _max = today()
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))
I am using a page filter right now that is set for Relative Date is in the last 1 years based on a Date Field and why I see two March Months 2022 and 2023.
How do I use the measure you had me create to make it work
I am still confused with this. What is [Net]? I am using my Date Column for [Date]
YTD Today =
var _min = eomonth(today(),-12)+1
var _max = today()
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))
User | Count |
---|---|
100 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |