Calculating YoY Difference without date field

[Anonymous]

Hi,

I need to find the difference in revenue from the current year vs last year but I don't have any date fields to use. Only fiscal year is available. Could you please assist by sharing if there is any way?

Here's what I have as source data and what I want to generate as output:

[Anonymous]

Thanks. Are there any resources that explain the DAX you used here?

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

All measures are in the attached pbix file.

Current Year Rev: = 
SUM ( Data[Revenue] )

Previous Year Rev: = 
VAR currentyear =
    INT ( LEFT ( SELECTEDVALUE ( Data[Fiscal Year] ), 4 ) )
VAR lastyeartable =
    FILTER ( ALL ( Data ), INT ( LEFT ( Data[Fiscal Year], 4 ) ) = currentyear - 1 )
RETURN
    SUMX ( lastyeartable, Data[Revenue] )

YoY variance: = 
IF (
    [Current Year Rev:] <> BLANK ()
        && [Previous Year Rev:] <> BLANK (),
    [Current Year Rev:] - [Previous Year Rev:]
)

[Anonymous]

Thanks. Much Appreciated!