datediff into power query

[jcastr02]

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)        

[edhans]

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
)

[Greg_Deckler · Accepted solution]

Depends on exactly what you want, but:

Number.RoundTowardZero(Number.From([Column1]) - Number.From(DateTime.LocalNow()))