DAX Calculation - Previous Period using Fiscal Year

[vanessafvg]

Hi 

i have a date dimension which has fiscal year periods defined in it, as well as calendar year periods

I am trying to get the Previous Years Fiscal Month Revenue

Previous Year Revenue = CALCULATE(
SUM('Registrations'[Revenue]),
FILTER(ALL('Date'),
'Date'[Fiscal Month] = 'Date'[Fiscal Month]
&& 'Date'[FYYear]='Date'[FYYear]-1))

unfortunately this is returning blank data,  

[v-ljerr-msft · Accepted solution]

Hi @vanessafvg,

Could you try the formula below to see if it works?

Previous Year Revenue =
VAR currentFYYear = 'Date'[FYYear]
VAR currentFiscalMonth = 'Date'[Fiscal Month]
RETURN
    CALCULATE (
        SUM ( 'Registrations'[Revenue] ),
        FILTER (
            ALL ( 'Date' ),
            'Date'[Fiscal Month] = currentFiscalMonth
                && 'Date'[FYYear]
                = currentFYYear - 1
        )
    )

Regards

[Anonymous]

Hello Guys.

I am in a similar situation, I need to get the sales for the WHOLE last fiscal year (for current date). 

But when I try this formula, I get Error:

Error: Calculation error in measure 'Sell In Full Last Year': A single value for column 'Fiscal Year' in table 'Date' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

How should it be changed?

Thanx in advance

[Anonymous]

Hello there,
Did you get the answer for this. I also need the same thing please reply.

[vanessafvg]

anyone out there?