Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Group,
we developed a formatter for M/PowerQuery a couple of weeks ago. You find it here:
https://powerqueryformatter.com
You can format M-code online or use our API - as we use the API for our (german) blog https://durchblick-durch-daten.de (formerly https://powerpivotinsights.de).
Please give it a try - and if you have any suggestions or if you find any problems, do not hesitate to send a bug report (link is on the website).
Thanks,
Holger
Very nice, I did something simple but it worked great! Turned this:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("dc3BCQAhDETRXnIWSWLGaC1i/21sFPawkJ3rY/hrkVAhqfwd7bIIIWopWVBPpZ1TKvob6keUU+OK+3NXQxvgyYC+ZremMgQT1hzeZ9h+AA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [z = _t, #"GAMMA (Excel)" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"z", type number}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"GAMMA (Excel)"})
in
#"Removed Columns"
Into:
let
Source = Table.FromRows(
Json.Document(
Binary.Decompress(
Binary.FromText(
"dc3BCQAhDETRXnIWSWLGaC1i/21sFPawkJ3rY/hrkVAhqfwd7bIIIWopWVBPpZ1TKvob6keUU+OK+3NXQxvgyYC+ZremMgQT1hzeZ9h+AA==",
BinaryEncoding.Base64
),
Compression.Deflate
)
),
let
_t = ((type text) meta [Serialized.Text = true])
in
type table[z = _t, #"GAMMA (Excel)" = _t]
),
#"Changed Type" = Table.TransformColumnTypes(Source, {{"z", type number}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type", {"GAMMA (Excel)"})
in
#"Removed Columns"
Much more readable and it had colors as well but those didn't paste over! Not your fault! 🙂
Hi Greg,
what do you mean with "colors didn't paste over"? If you cut/paste it to something like "word", this is working. If you copy"html" you can use it on your webstie (with colors). Ok, using the powerquery - we do not have a change because this is text only 🙂
Holger