penultimate date
1 Topic
Return Value based on Last Date and Return Value Based on Second to Last Date (Penultimate Date)
Hi there, This might be quite a simple one - sorry that I am new to DAX and learning. I have the following table (simplified) Asset Date Value aaa 24/07/2020 20 aaa aaa 25/07/2022 30 aaa 01/04/2019 50 aaa 04/06/2019 40 bbb 17/03/2021 70 bbb 10/02/2019 50 bbb bbb 14/03/2020 40 bbb 11/02/2018 80 bbb 10/02/2017 90 ccc 02/02/2019 30 ccc 02/02/2018 30 I am trying to create a table in my report that will reference this table to make it look like this: Asset Current Value Previous Value % Difference aaa 30 20 bbb 70 40 ccc 30 30 Basically I would like the asset listed 'distinctly', and then for current value column: - each decided by finding the most recent date, and returning the value For previous value - find the second to last most recent date and return the value For % difference - The % difference between the above two Any help really appreciated.Solved1.8KViews0likes5Comments