Forum Discussion
Solved
Date difference blank
Hi, I would like to calculate the number of days between two dates in a column. I have now solved this: = Duration.Days([M2.A Forecast Date] - [M1 Forecast Date]) But how can I add that this i...
Try the following formula as you are using Power Query:
if [M2.A Forecast Date] = null or [M1 Forecast Date] = null then null else Duration.Days([M2.A Forecast Date] - [M1 Forecast Date])
themistoklis
Community Champion
Community Champion
Try the following formula as you are using Power Query:
if [M2.A Forecast Date] = null or [M1 Forecast Date] = null then null else Duration.Days([M2.A Forecast Date] - [M1 Forecast Date])
thank you, it works 🙂
