Previous date value

[razvan_brais]

Hey guys.

I have a question. Is there a way to get in expression the previous date value?

If I have these dates :

21/03/2018

20/03/2018

19/03/2018

17/03/2018

And I would like to have this result

Current	Previous
21/03/2018	20/03/2018
20/03/2018	19/03/2018
19/03/2018	17/03/2018
17/03/2018	-

Thank you,

Razvan

[razvan_brais]

Kind of ,

But with only two columns : Current date(the date I select) , and Previous date ( previous date for selected date)

[razvan_brais]

Do you have the solution?

[fvelascog72]

Hi,

Try in expression:

sum({<HIST_DATE = {'>=$(=Date(Only(HIST_DATE)-1))'}>}Value)/1000

Saludos.

[razvan_brais]

I don`t need values for each KPI for previous day. I need to put as column header , Previous Date for previous values.

HIST_DATE - 1 won`t work because there is a gap between 26 and 24.

When I select 26 , the previous DATE should be 24 not 25

[sunny_talwar · Accepted solution]

May be try this

=Max({<HIST_DATE = {"$(='<' & Max(HIST_DATE))"}>}HIST_DATE)

[razvan_brais]

This is perfect.

Many thanks