Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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

     

     

3 Replies

  • dufoq3's avatar
    dufoq3
    Community Champion

    Hi Anonymous, don't try to read this code. You can create such table via User Interface and edit with GEAR icon