https://community.fabric.microsoft.com/t5/Power-Query/Issue-with-using-BinaryEncoding-Type-to-create-a-MonthEnd-Date/m-p/3964112#M129727 <P>Hi&nbsp;</P><P>&nbsp;</P><P>I am recreating a Power BI dashboard. I came across a MonthEnd table table that was created using the query below:</P><P>&nbsp;</P><P>&nbsp;= 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])</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Could someone please help me read the query or show me how to create the table?</P><P>&nbsp;</P><P>Thank you in advance.&nbsp;</P> Fri, 31 May 2024 10:41:45 GMT Anonymous 2024-05-31T10:41:45Z https://community.fabric.microsoft.com/t5/Power-Query/Issue-with-using-BinaryEncoding-Type-to-create-a-MonthEnd-Date/m-p/3964112#M129727 <P>Hi&nbsp;</P><P>&nbsp;</P><P>I am recreating a Power BI dashboard. I came across a MonthEnd table table that was created using the query below:</P><P>&nbsp;</P><P>&nbsp;= 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])</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Could someone please help me read the query or show me how to create the table?</P><P>&nbsp;</P><P>Thank you in advance.&nbsp;</P> Fri, 31 May 2024 10:41:45 GMT https://community.fabric.microsoft.com/t5/Power-Query/Issue-with-using-BinaryEncoding-Type-to-create-a-MonthEnd-Date/m-p/3964112#M129727 Anonymous 2024-05-31T10:41:45Z https://community.fabric.microsoft.com/t5/Power-Query/Issue-with-using-BinaryEncoding-Type-to-create-a-MonthEnd-Date/m-p/3964162#M129729 <P>Hi&nbsp;Anonymous</LI-USER>,&nbsp;don't try to read this code. You can create such table via User Interface and edit with GEAR icon</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> Fri, 31 May 2024 10:57:57 GMT https://community.fabric.microsoft.com/t5/Power-Query/Issue-with-using-BinaryEncoding-Type-to-create-a-MonthEnd-Date/m-p/3964162#M129729 dufoq3 2024-05-31T10:57:57Z https://community.fabric.microsoft.com/t5/Power-Query/Issue-with-using-BinaryEncoding-Type-to-create-a-MonthEnd-Date/m-p/3964470#M129733 <P>It works !!! Thank you&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="664745" data-lia-user-login="dufoq3" class="lia-mention lia-mention-user">dufoq3</a>&nbsp;</P> Fri, 31 May 2024 13:13:33 GMT https://community.fabric.microsoft.com/t5/Power-Query/Issue-with-using-BinaryEncoding-Type-to-create-a-MonthEnd-Date/m-p/3964470#M129733 Anonymous 2024-05-31T13:13:33Z https://community.fabric.microsoft.com/t5/Power-Query/Issue-with-using-BinaryEncoding-Type-to-create-a-MonthEnd-Date/m-p/3964613#M129736 <P>You're welcome <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P> Fri, 31 May 2024 14:28:42 GMT https://community.fabric.microsoft.com/t5/Power-Query/Issue-with-using-BinaryEncoding-Type-to-create-a-MonthEnd-Date/m-p/3964613#M129736 dufoq3 2024-05-31T14:28:42Z