Forum Discussion
Solved
Previous Quarter Comparison
Hi i need to produce the below table where it is comparing the previous 2 complete quarters. In the below example it would be financial Q4 compared to financial Q3 as we are currently in financial...
Hi
I ended up using the previousquarter function which has worked. I just need to add the Quarter Year into a slicer
Hello maurcoll
please try this measure
Last Completed YearQuarter =
VAR CurrentYear = MAX('Date'[FinancialYear])
VAR CurrentQuarter = MAX('Date'[FinancialQuarter])
-- Completed quarter is always one before the current
RETURN
IF(CurrentQuarter = 1,
(CurrentYear - 1) * 10 + 4, -- Q4 of previous year
CurrentYear * 10 + (CurrentQuarter - 1)
)
Thanks,
Pankaj Namekar | LinkedIn
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Hi
I'm getting a value of 20283, my calendar table goes forward to 2028.