Forum Discussion

Nobody1292's avatar
Nobody1292
Regular Visitor
4 years ago
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...
Need Help
  • themistoklis's avatar
    themistoklis
    4 years ago

     

    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])

     

speedramps's avatar
speedramps
Icon for Super User rankSuper User
4 years ago

Hi Nobody

 

We want to help you but it looks like you asked this question in a rush.

It does not make sense. "how can I add that this is only calculated if none of the dates is empty" â˜šī¸

Please take time to write questions clearly and you will get quicker answers. Thanks đŸ˜€