Previous value

[jyaul786]

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.

[Ahmedx · Accepted solution]

write another measure like this

Previous Day value fixed = 
       SUMX(VALUES(Date[Date]), [Previous Day value])