Forum Discussion

jcastr02's avatar
jcastr02
Post 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 dayss    ie.  1-7 days = 1 week tenure    8-14=2 week tenure, etc. 

 

DATEDIFF= DATEDIFF('cs exit'[when did you start with XYZ company?],today(),DAY)        

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

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago
    Depends on exactly what you want, but:

    Number.RoundTowardZero(Number.From([Column1]) - Number.From(DateTime.LocalNow()))
  • edhans's avatar
    edhans
    Community 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
)