Forum Discussion

bourne2000's avatar
bourne2000
Icon for Helper V rankHelper V
5 years ago
Solved

How 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...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    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's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

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's avatar
bourne2000
Icon for Helper V rankHelper V
5 years ago

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's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    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.