Forum Discussion
Datediff with value for blank
Hello Everyone,
What I am trying to do is simple. I have a starting date (Created date) and closed date (Resolved Date). With this formula I am using on the data table, when there are no dates in Resolved Dates it gives me blank. What I would like power bi to do is lable any row in resolved date column that is blank with the text "open" This way I know the ticket is still open and has not been resolved
Formula:
Resolved Duration = DATEDIFF('FreshService Data RAW'[Created Date],'FreshService Data RAW'[Resolved Date],DAY)
Hi Anonymous,
See attached PBIX, specifically the calculated column formula.
I hope this helps.
2 Replies
Hi Anonymous,
See attached PBIX, specifically the calculated column formula.
I hope this helps.