Forum Discussion

jb_karlsson's avatar
jb_karlsson
Frequent Visitor
6 years ago
Solved

Error handling in creating duration custom column

Hi, I'm quite new to Power Bi and I'm currently trying to transform a timestamp column Seconds into a duration type of column. But the null values generates an error and we don't want to remove or r...
Need Help
Show and Tell
  • Icey's avatar
    Icey
    6 years ago

    Hi jb_karlsson ,

    You can try to replace errors.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

VasTg's avatar
VasTg
Memorable Member
6 years ago

jb_karlsson 

 

Try this..

 

=if [Seconds] <> null then #duration(0,0,0,[Seconds]) else #duration(0,0,0,0)

 

If it helps, mark it as a solution.

Kudos are nice too

jb_karlsson's avatar
jb_karlsson
Frequent Visitor
6 years ago

Hi, no it didn't help, it removed the null values and replaced them with 0.00:00:00.

Regards Johan

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi jb_karlsson ,

    You can try to replace errors.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • jb_karlsson's avatar
      jb_karlsson
      Frequent Visitor
      6 years ago

      Thank you very much.

      Sometimes the answer is much easier then you expect:).

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        But it isn't supposed to be the case.

        Why should I go through this workaround from the first place it doesn't supposed to generate an error, it doesn't make sense