Forum Discussion
Return value for prior year based on selected date range
Hello, This measure returns the number of items in the table based on the date range selected and is working as expected. I would like to create another that looks at the same timeframe but returns t...
Hi Anonymous ,
I think the following may do the trick:
Test 4 Last Year = CALCULATE( [* Test 4] SAMEPERIODLASTYEAR( 'Claim Reported Date'[Calendar Date] ) )It should return the value of the measure you presented but on previous year.
If I answered your question, please mark my post as a solution.
Best,
Alf94
Solution Supplier
Solution SupplierHi Anonymous ,
I think the following may do the trick:
Test 4 Last Year =
CALCULATE(
[* Test 4]
SAMEPERIODLASTYEAR( 'Claim Reported Date'[Calendar Date] )
)
It should return the value of the measure you presented but on previous year.
If I answered your question, please mark my post as a solution.
Best,