Friend,
how to get previous value, by date
i have table:
| Date | Value |
| 01/01/2023 | 3 |
| 02/01/2023 | 5 |
| 05/02/2023 | 6 |
| 09/03/2023 | 9 |
| Total | 23 |
i have dax:
var date1=CALCULATE(MAX(table[date]),table[date]<MAX(table[date]))
return
CALCULATE(sum(table[value]),table[date]=date1)
but its give the result:
| Date | Value | Previous Day value |
| 01/01/2023 | 3 | |
| 02/01/2023 | 5 | 3 |
| 05/02/2023 | 6 | 5 |
| 09/03/2023 | 9 | 6 |
| Total | 23 | 6 |
but i would like to get the result like table below and sum of previous value at last:
| Date | Value | Previous Day value |
| 01/01/2023 | 3 | |
| 02/01/2023 | 5 | 3 |
| 05/02/2023 | 6 | 5 |
| 09/03/2023 | 9 | 6 |
| Total | 23 | 14 |
how can i achieve above using dax.
