Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |