Forum Discussion
RichOB
Post Partisan
Post PartisanCount based on date
Hi, how can I get the total count of properties that have an expiry date within each financial year? My financial year runs 1st April - 31st March. I make it: FY 24/25 = 4 FY 25/26 = 6 Pr...
Hi there, assuming you do not use Date table and you are going to use the Expiry Date in this sample table. You'd need to create one Column with DAX below for FY.
Financial Year = VAR Expiry = 'CountBasedOnDate'[Expiry Date] VAR FY_EndYear = YEAR(Expiry) + IF(MONTH(Expiry) >= 4, 1, 0) RETURN "FY " & RIGHT(FY_EndYear - 1, 2) & "/" & RIGHT(FY_EndYear, 2)In reporting, it will be,
Hope it helps:)
MasonMA
Super User
Super User
Hi there, assuming you do not use Date table and you are going to use the Expiry Date in this sample table. You'd need to create one Column with DAX below for FY.
Financial Year =
VAR Expiry = 'CountBasedOnDate'[Expiry Date]
VAR FY_EndYear = YEAR(Expiry) + IF(MONTH(Expiry) >= 4, 1, 0)
RETURN
"FY " & RIGHT(FY_EndYear - 1, 2) & "/" & RIGHT(FY_EndYear, 2)In reporting, it will be,
Hope it helps:)