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

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI

 

Pleasr try :

if(or(ISBLANK(SELECTEDVALUE([M2.A Forecast Date])),ISBLANK(SELECTEDVALUE([M1 Forecast Date]))),,Duration.Days([M2.A Forecast Date] - [M1 Forecast Date]))