Friday, June 5, 2020
Power Query - Dynamic & bulk change type
= Table.TransformColumnTypes(Source,List.Transform(List.RemoveFirstN(Table.ColumnNames(Source),2),each {_, type number}))
Subscribe to:
Posts (Atom)
Power Query - funcao limpa replace texto numero
//fnc_limpa_texto (TextValue as nullable text) => let SafeText = if TextValue = null then "" else TextValue, DigitsOnly...
-
There are two points to be evaluated: 1. If you want to discard the errors In this case, just run: #"Removed errors" = Table.Re...
-
====================================================== CSV: let Source = SharePoint.Files("https://site", [ApiVersion = 15]), ...
-
Code for creating a table Dim_Calendar Refresh Path let Source = "C:\Temp\datasets\board\csv\__20200210_120926_.ARCHIVE" ...