Merge two dates columns in a single slicer

[Shakaze]

Hello everyone,

I'm currently working on creating a dashboard with contracts' datas.

However i'm stuck on the date part.

I have 2 columns : StartDate and EndDate which are dates of contracts.

At the moment, I have 2 slicers and my goal is to have only one where users could just select when the slicer starts and where it ends (and so the contracts).

I have tried to create a calendarauto table but i simply cannot create what i really want.

If you guys have any ideas !

Thank you

[amitchandak · Accepted solution]

@Shakaze ,

You can create a calendar like

calendar(Min(Min(Table[Start Date]), Min(Table[End Date])) , MAx(MAx(Table[Start Date]), MAx(Table[End Date])) )

Use this HR blog having similar calculation 

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

or the attached files

[Shakaze]

Hello Amit,

Thank you very much, it's working perfectly !