Forum Discussion
Calculating YoY Difference without date field
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:
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:] )
3 Replies
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:] )