Forum Discussion
Anonymous
2 years agoNot applicable
Issue with using BinaryEncoding.Type to create a MonthEnd Date table
Hi
I am recreating a Power BI dashboard. I came across a MonthEnd table table that was created using the query below:
= Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjbQNzDRNzIwMlGKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t])
Could someone please help me read the query or show me how to create the table?
Thank you in advance.
Hi Anonymous, don't try to read this code. You can create such table via User Interface and edit with GEAR icon