Forum Discussion

game1's avatar
game1
Helper III
2 years ago

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,  ...
Show and Tell
Tutorial Requests
Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

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:

Sequential - Microsoft Fabric Community

  • game1's avatar
    game1
    Helper III
    2 years ago

    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?