Forum Discussion
Helper VHow to create a calendar table for two date columns?
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.
Helper V
Thanks for your quick reply. I am getting an error.
{Number.From([Joining Date])..Number.From([Leaving date])} --> What this forumla doing? Is it subtracting the joining and leaving date?
I also wanted to do an analysis separately on leaving and joining dates, I might be using a date slicer for both joining and leaving dates on separate page. Can you please advise whether the above formula works for this?. Sorry I am a novice to the Power BI
- Ashish_Mathur
Super User
Hi,
Share the link from where i can download your PBI file. If you imported data in the PBI file from an MS Excel file, then i will need that MS Excel file as well. If data is confidential, then please anonymise the data before sharing the download link.
- bourne2000
Ashish_Mathur Thanks. Please find the pbix and excel file. I gave some test data
You can download the file from the below link,
- Ashish_Mathur
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.