Dax Query or Custom Column for Two dates with today

[dbollini]

I have CreatedDate & Updated Date in my database so now i wnat to get the no of days it has been sitting in the current state from Updated date to today and if updateddate is NULL then i should use CreatedDay to Today in single column or Dax query .

I created custom column and Dax query but with only one column UPdated date Duration.TotalDays([Today] - [UpdatedDate])

but i need if it updateddate is null then use createddate

[AlB · Accepted solution]

Hi @dbollini 

In PQ, create a custom column:

= if [UpdatedDate] = null then  Duration.TotalDays([Today] - [CreatedDate]) else Duration.TotalDays([Today] - [UpdatedDate])

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[dbollini]

Thank you so much i was using the same query but was doing one small mistake with column name now fixed .