topic Re: Values replace by "Not Resolved Yet" in DAX Commands and Tips

Values replace by "Not Resolved Yet"

sdhn — Thu, 18 Nov 2021 16:18:59 GMT

Hi All,

I have calculated column as :

Elapsed = [Resolved Date Time] - [Created]

Many Resolved Date Time rows has no value.

When there is no value its give me result as:

I want to replace this for "Elapsed" column by either no value, Zero (0) or 'NoT Resolved Yet'.

Any help will be appreciated. thanks

smpa01 — Thu, 18 Nov 2021 16:43:38 GMT

sdhn can you try this

Column = VAR _diff = [Resolved Date Time] - [Created] RETURN IF([Resolved Date Time]=BLANK(),0,_diff)

sdhn — Thu, 18 Nov 2021 17:48:05 GMT

Please see above for error message. Thanks

smpa01 — Thu, 18 Nov 2021 17:53:05 GMT

sdhn you missed the underlined part

VAR _diff = [Resolved Date Time] - [Created]
RETURN IF([Resolved Date Time]=BLANK(),0,_diff)

sdhn — Thu, 18 Nov 2021 19:47:48 GMT

Thanks