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, ...
game1 I would add an offset column to your data which is the number of days from today. So, for example, start with today being 0 and it increments up from there. Then you could build a simple measure that filters for <=7 and <=30. Can be done in Power Query or DAX. Here is the DAX version:
I use datesDiff =
SWITCH(
TRUE(),
Table[Date] >= TODAY() - 7 && Table[Date] < TODAY(), "7 last days",
Table[Date] >= TODAY() - 30 && Table[Date] < TODAY(), "30 last days",
TRUE(), "more than 30 days"
)
but, it is only give the good range for the first one (7 last days). For the other, the range are not good. Why? How correct that?