Forum Discussion
Add to a table previous days values
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...
- So, that should be something like:
Column = IF([Date] < (TODAY() - 5),FALSE(),TRUE())
Tough to say but generally you would want to unpivot those date columns.
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.
- So, that should be something like:
Column = IF([Date] < (TODAY() - 5),FALSE(),TRUE()) 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")returnIF(IStoday=currentrowdate,"Yes","No")