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