Add to a table previous days values

[Anonymous]

Hallo,

How would it possible to creat such a table with an automatic shift of the days depening on the filter chose. 

The filter is only for one date, then the table has to show the day and four days before. 

Value	Fri 17/01	Mon 20/01	Tue 21/01	Wed 22/01	Thu 23/01
A	0.9 t	0.0 t	0.4 t	0.5 t	0.9 t
B	0.5 t	0.0 t	0.0 t	0.2 t	0.6 t
C	0.6 t	0.0 t	0.0 t	0.5 t	0.7 t
D	6.0 t	0.0 t	0.2 t	5.0 t	7.7 t
E	0.0 t	0.0 t	0.0 t	0.0 t	0.0 t
F	1.1 t	0.0 t	0.0 t	0.5 t	1.1 t
G	16.4 t	0.0 t	0.0 t	14.3 t	16.1 t
H	0.0 t	0.4 t	0.0 t	0.0 t	1.1 t
I	0.0 t	0.0 t	0.0 t	0.0 t	5.3 t
J	0.0 t	0.0 t	0.0 t	0.0 t	15.1 t

[Greg_Deckler]

Tough to say but generally you would want to unpivot those date columns.

[Anonymous]

@Greg_Deckler @amitchandak 

I need to creat a column simmilar to the one in the picture to have a true or false values. If the date was in the last 5 days then True if not then False. 

[Greg_Deckler · Accepted solution]

So, that should be something like:

Column = IF([Date] < (TODAY() - 5),FALSE(),TRUE())

[Anonymous]

@Greg_Deckler @amitchandak 

Something simmilar to this one that I created for the current day.

Current day =

var currentrowdate = FORMAT('Date'[StartDate], "mm/dd/yyyy")

var IStoday = FORMAT(NOW(),"mm/dd/yyyy")

return

IF(IStoday=currentrowdate,"Yes","No")

[amitchandak]

Is this final data format. Can you please explain with an example.

[Anonymous]

@amitchandak 

I need to creat a column simmilar to the one in the picture to have a true or false values. If the date was in the last 5 days then True if not then False.