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.
Super UserHi,
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.
Helper VAshish_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.
- bourne2000
Ashish_Mathur Thanks for your support yesterday. I tried to replicate the same in my data. I am getting the below error,
{Number.From([Hire Date])..Number.From([Terminated date])}
Can you please advise?
- Ashish_Mathur
Hi,
Maybe your systems understand the mm/dd/yyyy format (not the dd/mm/yyyy format). In the source Excel document, ensure that all dates are entered (not just formatted) in the mm/dd/yyyy format.