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))
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
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Best regards, JiHwan Kim
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!