Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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. |
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 .
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |