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.
hi guys
I need an IF statement that will filter the months that are in the current fiscal year.
our fiscal year changes mid year e.g june 1 -> may 31
how can i make an IF statemant that only filters dates during the current fiscal year.
@paulfink , You can create a new column like
Year Type =
var _year = if(month(today())<=5, year(today()) -1, year(today())
var _start = date(_year,6,1)
var _end =date(year+1,5,31)
Switch( True(),
[Date] >= _start && [Date] <=_end , "This FY",
"Other"
)
i dont need a fiscal year column - that has already been set up. how do i filter it so it shows the current fiscal year inside an IF statement so it always shows the current fiscal year.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |