Forum Discussion

jcastr02's avatar
jcastr02
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

datediff into power query

I have a date diff column that added , but i'd like it to show up in my power query.  How can I ahieve this?   I am trying to create categories based on the amount of time difference between the two ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago
    Depends on exactly what you want, but:

    Number.RoundTowardZero(Number.From([Column1]) - Number.From(DateTime.LocalNow()))
edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
6 years ago

If you are doing two dates and want the weeks between, per your definition, this should work

 

Number.RoundAwayFromZero(
    Number.From([Date 2] - [Date 1]) / 7
)