Forum Discussion
Filter date for the last 7days
Hello! I would like to create a new column to filter the TABLE[Date] which is in YYYY-MM-DD HH:mm:ss format, so that it just returns me the list of the last 7 days when I choose the box last7days, ...
Not functionnig. I try this:
datesDiff = if(datediff(Table[Date], Today(), DAY) <=7, "7 last days", "more than 7 days") but I dotn have the good range. For example, from today, it's supposed to return me the lsit of date beetween 2023-12-07 to 2023-12-13. Where is the problem? Do I have other option? Thanks!