Hello there.
I am struggling with the problem I can't resolve very many hours, read all articles, tried again and again (using DAX and Excel formulas) and nothing. I hope somebody can crack this nut.
Here is the problem:
The goal is to get the second last or previous value in the last row for each unique client id (clients can be repeated) based on date and compare it in another column. So far I have used =LOOKUP(2;1/([id]=[@[id]]);[amount]) formula to get the last value in one column and then used pivottable to quickly see each client last value. Now I am in the situation I need to compare the last and the second last value to compare both values. I tried to make some modifications and even tried to write with DAX but I am just out of idea, because nothing works.
One of solution is create advanced formula in data sheet or another create DAX formula. So it doesn't matter to me as data is formatted as table.
Below I have attached the file with sample. And highlighted cells for the first sample.
Very appreciated any help. And I hope users will find something useful.
Bookmarks