How to create a date filter using date column

[Anonymous]

Hi 

I have created date as two dimensions and its working fine but am expecting to create that dimension as one column. 

Step 1:

Last6Month = VAR six =1.* (MasterTable[MaxDate]-MasterTable[6Month])

RETURN if(MAX(SiteMasterTable[Date]) - MasterTable[Date] <six,"6M","Older")

Similarly I have created that date filter for Last12Month also.

Here am creating these two columns into one column but its not working as expected,

 Step2:

MonthSlicer = VAR six =1.* (MasterTable[MaxDate]-MasterTable[6Month])
 VAR eighteen =1.* (MasterTable[MaxDate]-MasterTable[18Month])

RETURN   if(MAX(SiteMasterTable[Date]) - MasterTable[Date] <six,"6M",
                if(MAX(SiteMasterTable[Date]) - MasterTable[Date] <six,"12M","Older"))

Here MasterTable[MaxDate] --> it contains max date from date column
MasterTable[6Month] & MasterTable[18Month] --> it contains 6M & 18M  date.

Could you please suggest me how to acheive this into one column.

Regards,

Yuvaraj

[v-chuncz-msft]

@Anonymous,

Based on your requirements, you could use the relative date slicer.

[Anonymous]

Yes. we can use relative date slicer also but am expecting without relative slicer, how we can able to acheive this scenario.

Regards,

Yuvaraj

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may refer to the following posts.

• https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Options/m-p/573381#M270846
• https://community.powerbi.com/t5/Desktop/Use-a-date-slicer-to-filter-on-a-period-instead-of-a-single-date/m-p/588265#M278953