Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
There is Actual Start and Actual End Date. Both columns have null values as project is in progress or no given date. Keep getting errors on below. Any suggestions? Just trying to get a number value on the difference between these 2 columns. Thanks
Days Between = If('BI Projects'[Actual Start]=BLANK(),"",DATEDIFF('BI Projects'[Actual Start], 'BI Projects'[Actual End],DAY))
Solved! Go to Solution.
Hi @ResearchDev
PLease try
Days Between =
IF (
'BI Projects'[Actual Start] <> BLANK ()
&& 'BI Projects'[Actual End] <> BLANK (),
DATEDIFF ( 'BI Projects'[Actual Start], 'BI Projects'[Actual End], DAY )
)
Thanks so much! Worked like magic!
Hi @ResearchDev
PLease try
Days Between =
IF (
'BI Projects'[Actual Start] <> BLANK ()
&& 'BI Projects'[Actual End] <> BLANK (),
DATEDIFF ( 'BI Projects'[Actual Start], 'BI Projects'[Actual End], DAY )
)
Thanks so much!
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.