Forum Discussion
Calculate time diffrence between two rows based on criterias
Helle Petter120
yes, we are almost there..... hoping that my function is working properly 🙂
your query should look something like this
let Quelle = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTIEYRM9QyM9IwNDSwUDCysDA6VYHVyShqY4JS1hkk5ACQtcxmKXNMItaWlljCZpCpc0NABLxgIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Area = _t, Drift = _t, Date_Time = _t]), changedtype = Table.TransformColumnTypes(Quelle,{{"Area", type text}, {"Drift", Int64.Type}, {"Date_Time", type datetime}}), FinalTable = fnConvertTable(changedtype) in FinalTablewhere my function is the last variable that is then passed as result with the in-statement. The part above the FInalTable-variable should be your old query...
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy
Ok Jimmy801 i thinking im almost there, just clarify a few things:
After the import of "Tabell1" i go and create a blank query and add the code.
Then it ask me to add a parameter where i chose "Tabell1"
Then i rename the function to "fnConvertTable"
Then "Tabell1" looks like this
When i open the advanced Editor it looks like this:
Then i pass the new code
And i its here im guessing om doing something wrong?
Because i get this error: Expression.SyntaxError. Token Eof expected
Helle Petter120
yes, we are almost there..... hoping that my function is working properly 🙂
your query should look something like this
let
Quelle = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTIEYRM9QyM9IwNDSwUDCysDA6VYHVyShqY4JS1hkk5ACQtcxmKXNMItaWlljCZpCpc0NABLxgIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Area = _t, Drift = _t, Date_Time = _t]),
changedtype = Table.TransformColumnTypes(Quelle,{{"Area", type text}, {"Drift", Int64.Type}, {"Date_Time", type datetime}}),
FinalTable = fnConvertTable(changedtype)
in
FinalTable
where my function is the last variable that is then passed as result with the in-statement. The part above the FInalTable-variable should be your old query...
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy