Working with case statement in power bi

[lukaspowerbi]

I have a query including a case statement(copied below) that run in SQL Server 2012 and I just took it into Power BI. 

My slicer visual (Join Date Range) equals the Case statement from SQL Server:

case
when mbr_join_date>=getdate()-7 then 'Last Week'
when mbr_join_date>=getdate()-30 then 'Last Month'
when mbr_join_date>=getdate()-60 then 'Last 60 Days'
when mbr_join_date>=getdate()-90 then 'Last 90 Days'
else 'Last Fiscal Year'

A little bit about data: People are basically joining an organization and as of now the slicer works as a case statament meaning once I choose 'Last Week' Joins I get person A,B and C, however, when I choose 'Last Month' I would expect person A.B,C to be included in the result set but they are not. I know it is because my sql case statement eliminates those. 

Can you please advice how can I accomplish person A,B, and C appear in both, 'Last Week' and 'Last Month' and basically in other options too? 

It doesn't matter if the solution is in SQL or power bi as long as it works.

Thank you.

[v-chuncz-msft · Accepted solution]

@lukaspowerbi,

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

[lukaspowerbi]

@v-chuncz-msft 

Thank you. Works great.

[popov]

Hello, @lukaspowerbi
Try this approach I think, is ideal for you case