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))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
86 | |
85 | |
68 | |
66 | |
64 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |