Error handling in creating duration custom column

[jb_karlsson]

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 replace the null values before creating the duration column. Preferably the it should say null instead of Error in the new column.

Has anyone any solution for this?

Regards Johan

[VasTg]

@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]

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

Regards Johan

[Icey · Accepted solution]

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]

Thank you very much.

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

[Anonymous]

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