Forum Discussion
Dax date help
Our fiscal year is July 1st - June 30th. We currently have 2023 data for July - January. I am trying to comparing last years 2022 data for July - January. The formula below gives me wh...
My fault, enddate is wrong. The solution:
VAR EndDate = DATE(YEAR(StartDate), MONTH(StartDate)-12, DAY(StartDate))