Forum Discussion

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost 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
Icon for Post Prodigy rankPost 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.