Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am trying to calculate the deifference between two dates only. If the date in one column is 01 January 1900 then leave then do nothing or return blank, if it is not 01 January 1900 then do the date diff calc and return the amount of days difference. I;ve tried different combinations but can't get it to work.
Days to Close1 = IF(DATEVALUE('Job Dates LH'[LH_Job_Completed_Date])= "01 January 1990", BLANK(), DATEDIFF('Job Dates LH'[LH_Job_Completed_Date],'Job Dates LH'[LH_Job_Opened_Date],DAY))
Solved! Go to Solution.
Hi @DRossi ,
Try this:-
Days to Close1 =
IF (
DATEVALUE ( 'Job Dates LH'[LH_Job_Completed_Date] ) = DATE ( 1990, 01, 01 ),
BLANK (),
DATEDIFF (
'Job Dates LH'[LH_Job_Completed_Date],
'Job Dates LH'[LH_Job_Opened_Date],
DAY
)
)
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi @DRossi ,
Try this:-
Days to Close1 =
IF (
DATEVALUE ( 'Job Dates LH'[LH_Job_Completed_Date] ) = DATE ( 1990, 01, 01 ),
BLANK (),
DATEDIFF (
'Job Dates LH'[LH_Job_Completed_Date],
'Job Dates LH'[LH_Job_Opened_Date],
DAY
)
)
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |