Slicer with Period Start & Period End Date

[sraj]

Hi Everyone,

Can someone please tell me if this is possible with any measure?  I have these two fields Payment Period Start Date & Payment Period End Date, would like to know if I can have one slicer for these so I can give the users the Between or Date range option?

Thank you!!

[amitchandak · Accepted solution]

@sraj , you can connect both of them with a date table. One will active and one inactive. You can join them using use relation.

see how to use userelation : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[Icey · Accepted solution]

Hi @sraj ,

How about this?

1. Create a seperate Dates table.

Dates = CALENDAR(DATE(2020,1,1),DATE(2020,4,30))

2. Create a measure.

Measure =
VAR MaxDate =
    MAX ( Dates[Date] )
VAR MinDate =
    MIN ( Dates[Date] )
RETURN
    IF (
        MAX ( 'Table'[Payment Period Start Date] ) >= MinDate
            && MAX ( 'Table'[Payment Period End Date] ) <= MaxDate,
        1
    )

3. Put the Measure into "Filters on this visual" of the visuals needed and set as 1.

4. Test.

BTW, .pbix file attached.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24]

Try with the UNION function.

Table = UNION( DISTINCT(Table[StartDateColumn]), DISTINCT(Table[EndDateColumn]) )

[amitchandak · Accepted solution]

@sraj , you can connect both of them with a date table. One will active and one inactive. You can join them using use relation.

see how to use userelation : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...