Records that are true for more then one IF statement.

[amtrakrob]

Hello All..
I have an Exeration Date field.  I'm trying to create a filter that has 3 options 

Due within 30 days, Due within 60 days, Due within 90 days, Due within 120 days, Due within 180 days, Due within 365 days , Expired 
My problem... 
I can do and if statemet that does 1-30 then 31 to 60, then 61-90, etc,  But what I need is an if statement that  includes all records under the number.  Example if I select the Due Within 120 days option, it should should show the records due within 30,60, and 90 also. 
thanks in advance.

[johnt75 · Accepted solution]

You could create a table like

Slicer Dates =
SELECTCOLUMNS (
    UNION (
        GENERATE ( { "Due within 30 days" }, CALENDAR ( TODAY (), TODAY () + 30 ) ),
        GENERATE ( { "Due within 60 days" }, CALENDAR ( TODAY (), TODAY () + 60 ) ),
        GENERATE ( { "Due within 90 days" }, CALENDAR ( TODAY (), TODAY () + 90 ) ),
        GENERATE ( { "Due within 120 days" }, CALENDAR ( TODAY (), TODAY () + 120 ) )
    ),
    "Range", [Value],
    "Date", [Date]
)

Create a many-to-many relationship from this new table to your fact table but make it single direction so that the slicer table filters your fact table. Use the range column in your slicer and it will filter to those dates which fall in the appropriate range.

[amtrakrob]

Thank you very much!!!
That worked