Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
im trying to get the values for the previous fiscal month and Previous Quarter using set analysis.
My current formula is
Current Month:
=Sum({<FQuarter=,FMonth=, [Date]= ,FYear={$(vMax_Year)}, fMonth={$(vMax_Month)}>}[Actuals])
Current Quarter:
=Sum({<FQuarter=,FMonth=, [Date]= ,FYear={$(vMax_Year)}, FQuarter_Num={$(vMax_Quater)}>}[Actuals])
my fiscal year starts in September .
i don't want to do Fmonth-1, because what if i was in the 1st month of the fiscal year.
Please let me know what i am doing wrong