Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
dshah12
Helper II
Helper II

Fiscal Year from Date

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 

Fiscal Year =
VAR CurrentYear = YEAR(cmhc_drawscheduleitem[cmhc_date])
VAR fsNextYear = CurrentYear + 1
VAR fsPreviousYear = CurrentYear - 1

RETURN
IF(
    MONTH(cmhc_drawscheduleitem[cmhc_date]) >= 4,
    CONCATENATE(CurrentYear, CONCATENATE("-", fsNextYear)),
    CONCATENATE(fsPreviousYear, CONCATENATE("-", CurrentYear))
)
1 REPLY 1
lbendlin
Super User
Super User

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
)

 

Helpful resources

Announcements
ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.