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
