Create Conditional Filter

[Anonymous]

Hello Community Members,

I am trying to create a conditional filter. Basically i have two dates columns -- Create Date and Request Date.

 on all my tabs -- i will use create date as a filter to give range filter, now i want to create a hidden filter which says

Request date >=2018 and Request Date <= Create date's end date 

[amitchandak]

@Anonymous , this condition you have to give in you measure filter

[Tahreem24]

@Anonymous ,

Create DAX Column like below:

Date Status = IF(Request date >=2018 && Request Date <= Create end date ,1,0)

Then on visual level filter of your date range slicer select 1 from DateStatus created above. Just like below SS:

[Anonymous]

@Tahreem24 Thanks, but I tried this at the first place, this gives me wrong value, lets say if Create date slicer is set to Jan 2019 till dec 2019 then the request date also filtered out, I want irrespective of create date Dec 2019 selection it should give me all values of request date till 2020.

[v-kelly-msft]

Hi @Anonymous ，

Create a calculated column as below：

Date available = IF('Table'[Request Date]>=DATE(2018,1,1)&&'Table'[Request Date]<=MAX('Table'[Create Date]),1,0)

Then in the slicer of "create date",put the column in the filter field and select 1,see as below:

For the related .pbix file,pls click here.

If it is not what you need ,show me your expected output via my sample data.

Much appreciated.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[rubinboer]

add a table Myslicer Dates = CALENDERAUTO() to your model and use it as the date for the slicer ;). reference it you your table.

[Anonymous]

thts not the requirement.

[rubinboer]

sorry i could not get that frm the reuirement. as the slicer is move the visuals adjust to the max date of the slicer. by have calender fix to your date , why the second filter?

use CALENDAR(date you want to start from 2018, max(MAX(YourTable[CreateDate]))