Forum Discussion
Dax Query or Custom Column for Two dates with today
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
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.
2 Replies
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.
Thank you so much i was using the same query but was doing one small mistake with column name now fixed .
