Forum Discussion
Shakaze
3 years agoFrequent Visitor
Merge two dates columns in a single slicer
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 contra...
- 3 years ago
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
or the attached files
amitchandak
Super User
3 years agoShakaze ,
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
or the attached files
- Shakaze3 years agoFrequent Visitor
Hello Amit,
Thank you very much, it's working perfectly !