Forum Discussion

Y-Hernandez99P's avatar
Y-Hernandez99P
Frequent Visitor
6 years ago
Solved

Error checking if a field is empty time type

Good morning, I hope you're all right. My problem is that with a table I have, I have to do operations with some fields that from the database come as String and had this column to get a data: ...
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , Y-Hernandez99P 

    This error often occurs  when  you try to use both one type value (text) and another  type value(time) in one calculate column so power bi can't auto analysis data type of this calculated column.

     

    Here are some points to note.

    1.replace all "" as null in query editor

     

    2.change all of your  date column  Datatype  from "time"  to "text"

    3. due to " There is  only one record" is  text type , so  make sure your calculate column data type is text rather than time

    The result is  as followings.

    Here is  a demo.

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi , Y-Hernandez99P 

This error often occurs  when  you try to use both one type value (text) and another  type value(time) in one calculate column so power bi can't auto analysis data type of this calculated column.

 

Here are some points to note.

1.replace all "" as null in query editor

 

2.change all of your  date column  Datatype  from "time"  to "text"

3. due to " There is  only one record" is  text type , so  make sure your calculate column data type is text rather than time

The result is  as followings.

Here is  a demo.

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.