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.