Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I am using Power Bi Desktop to develop report.
I need to add new column that computes elapsed time (Resolved date – Created date = Elapsed)
Both columns are date. Do I need to write mesaure ? etc
Please advise
Thanks
Solved! Go to Solution.
Elapsed =
VAR _diff = [Resolved Date Time] - [Created]
RETURN IF([Resolved Date Time]=BLANK(),0,_diff)
Elapsed =
VAR _diff = [Resolved Date Time] - [Created]
RETURN IF([Resolved Date Time]=BLANK(),0,_diff)
Hi there,
thanks for your feedback. But I am not getting correct values.
1)
2)
Thanks
Yeah, I don't get that either with my table.
From:
Hi @sdhn
Try this:
Elapsed = [Resolved date]-[Created date]
And change the new column data type to Whole number, Output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Hi @sdhn , see the comment about about the error I get with that equation: The value for 'Created Date' cannot be determined. Either the column doesn't exist, or there is no current row for this column.
Hi there ,
Thanks
This seems work. Only issue when we have no value in Resolved date time gives some numbers as:
@sdhn you can create a measure like this
difference = DATEDIFF(MAX('Table'[Created date]),MAX('Table'[Resolved date]),DAY)
or a calulated column
Column = CONVERT('Table'[Resolved date]-'Table'[Created date],DOUBLE)
whatever you prefer
@sdhn did you try the above?