Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I am getting data using the direct query and wanted to create a fiscal year range from date but it does not work from below DAX it gives
2022-2023.0 and similar redundant
This should work, but can be refactored
Fiscal Year =
VAR CurrentYear = YEAR(cmhc_drawscheduleitem[cmhc_date])
RETURN
IF(
MONTH(cmhc_drawscheduleitem[cmhc_date]) >= 4,
CurrentYear & "-" & (CurrentYear+1),
(CurrentYear-1) & "-" & CurrentYear
)
User | Count |
---|---|
119 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
177 | |
85 | |
70 | |
63 | |
55 |