Create last x days/weeks/month in dropdown filter

[Anonymous]

Hi, 

I'm looking to create a dropdown date filter with choices like ; 

filter

Last 7 days

Last 2 weeks

Last month

...and so on

This will act like a date filter on respective visuals. Please let me know if this is possible in PowerBI

.

[v-diye-msft · Accepted solution]

Hi @Anonymous 

You can create several measures list the 

Last 7 days

Last 2 weeks

Last month

...and so on

 and then try something like this:

Final Value 1 = 
IF(HASONEFILTER(Table[slicer]),
    SWITCH(SELECTEDVALUE(Table[slicer]),
        "Last 7 days", [Measure 1],
        "Last 2 weeks", [Measure 2],
        "Last month", [Measure 3]
    ),
   BLANK()
)

here're also other similar threads could be your reference:

https://community.powerbi.com/t5/Desktop/Control-Range-Date-by-Dropdown-filter/m-p/977818 

[MFelix]

Hi @Anonymous ,

Believe that you need to create a auxiliar table with the information and then make a switch measure to filter out your information something similar to:

ID	Type	Period	Type of Period
1	Last Week	7	Day
2	Last 2 Weeks	7	Day
3	Last Month	1	Month

Then make a formula similar to:

Measure =
CALCULATE (
    [Measure],
    SWITCH (
        SELECTEDVALUE ( Table[ID] ),
        1, FILTER (
            ALL ( DateTable ),
            DateTable[Date] <= MAX ( DateTable[Date] )
                && DateTable[Date] <= DATEADD ( DateTable[Date], - MAX ( Table[Period] ), DAY ),
2, .....

        )
    )
)

So you can dinamically add dates.

If you want some more details can you please share a sample data?