Forum Discussion

Justas4478's avatar
Justas4478
Post Prodigy
2 years ago
Solved

Calendar +1 Year from current date

Hi, I created calendar using this Query: let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjbQNzDWNzIwNFWKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _...
Need Help
  • Justas4478's avatar
    Justas4478
    2 years ago

    AlienSx Thanks it worked.
    I did try to move it before but it wasnt working for some reason. Maybe someting else was messed up.
    Here is working Query:
    Table.AddColumn(#"Changed Type", "EndDate", each Date.AddYears(Date.From(DateTime.LocalNow()), 1))

AlienSx's avatar
AlienSx
Super User
2 years ago

Justas4478 move , 1 to the left. Must be , 1)) in the end.

Justas4478's avatar
Justas4478
Post Prodigy
2 years ago

AlienSx Thanks it worked.
I did try to move it before but it wasnt working for some reason. Maybe someting else was messed up.
Here is working Query:
Table.AddColumn(#"Changed Type", "EndDate", each Date.AddYears(Date.From(DateTime.LocalNow()), 1))