Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculating Difference Between Two Dates using Multiple If statements

I have another multiple "if statement" that I'm having issues with.    PKG.1_DATE1 =1/1/2020 PKG.1_DATE2 = 1/14/2020  PKG.2_DATE1 = 1/2/2020 PKG.2_DATE2 = 1/20/2020    This worked Custom Colu...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

Do you mean to calculate the difference with Duration.Days()? It should be "Duration.Days( [PKG.1_DATE2]-[PKG.1_DATE1] )/7"

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    v-eachen-msft See message 5. I'm already using the Duration Days in my power query. I need to calculate the Duration Days from the latest package date.