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.
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
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |