Forum Discussion
bourne2000
Helper V
Helper VHow to create a calendar table for two date columns?
Hi I am building an HR Analytics dashboard. My data has the Employee joining date and the Employee leaving date. I would like to do an analysis using employee joining and leaving dates. I wa...
Your test data was incorrect. Your leaving date was before the joining data - i made that correction. Download the PBI file from here.
The next time you share data, please atleast ensure that you share logical data.
Ashish_Mathur
Super User
Super UserHi,
In the Query Editor, you should write this custom column formula
={Number.From([Joining Date])..Number.From([Leaving date])}
This will create an additional column with one date per cell between the Joining date and Leaving date. Your Calendar Table should then be related to this Date column.