cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## 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,  I would have only the dates of the last 7 days and for the list of the last 30 days,  I would have only the dates of the last 30 days.

So, I want 2 box:

last7days

last30days

THANKS.

3 REPLIES 3
Helper II

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!

Super User

@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

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Helper II

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?

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors