Forum Discussion
Solved
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 C...
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.
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 .