Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to calculate the Overdue time difference

Hi everyone,   I have been trying to get a result of time difference and also to identify when it is overdue for a particular entry. Asset number will always be unique. Hope someone can assist me w...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Based on the error message it would seem to me that you have stored this DateTime data inside Power BI using the datatype of "Text".

     

    My recommendation would be to go into Edit Queries and change the data type of both columns to "DateTime".

     

     

    For the "Overdue" portion, i'd simply create a new column (do this from inside Edit Queries) to flag if any row is overdue.  This could be done from the Add Column option and simply use

    [Asset_Exit_DateTime] > [Asset_Estimated_Exit_DateTime]

    Set this column to be of type "True/False"

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Based on the error message it would seem to me that you have stored this DateTime data inside Power BI using the datatype of "Text".

 

My recommendation would be to go into Edit Queries and change the data type of both columns to "DateTime".

 

 

For the "Overdue" portion, i'd simply create a new column (do this from inside Edit Queries) to flag if any row is overdue.  This could be done from the Add Column option and simply use

[Asset_Exit_DateTime] > [Asset_Estimated_Exit_DateTime]

Set this column to be of type "True/False"

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks Anonymous. I am now getting the details without any error and also able to derive overdue(true/false). Now, finding hard to visualize the "Duration" field ie. time difference data. can you suggest the best way to represent the info?

 

appreciate your help and assisntance.

 

regards