Return Value a Year Ago

[Anonymous]

Hi all,

I am trying to show a 1-Year Ago Mortality Rate using the below formula, but get the same number as the date selected for the table using a filter.

1-Year Ago Mortality rate= CALCULATE(Sum('Test'[Mortality Rate]), DATEADD('Test'[Date].[Date], -1, Year))

Any ideas?

[Jihwan_Kim]

I am not sure how your data model looks like, but please try the below.

- create a Dim-Date Table

- assign as a date table

- create a relationship between the Test table and Dim-Date table

- use 'Dim-Date'[Date] column in your measure