Forum Discussion

Justas4478's avatar
Justas4478
Post Prodigy
2 years ago

Controlling years on source table date

Hi I have this Query: Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjbQNzDWNzIwNFWKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Try:


Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjbQNzDWNzIwNFWKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Start Date" = #"custom1"[Second Column]),

 

--Nate

  • Justas4478's avatar
    Justas4478
    Post Prodigy
    2 years ago

    Hi, Anonymous I am getting cycle reference error.

    Sorry for misunderstanding instead of trying to incorporate column what I needed was only Date.AddYears function.