Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.
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.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
76 | |
72 | |
71 | |
48 | |
41 |
User | Count |
---|---|
54 | |
48 | |
33 | |
32 | |
28 |