Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
The following query generates strange behavior both in the latest version of PBI desktop and in excel:
let
Source = #table({"FaseID"}, {{"0. N/A"}, {"1. Ide"}, {"2. Valg av løsning"}, {"3. Utvikling"}, {"4. Utrulling"}, {"5. Avsluttet"}}),
#"Inserted Text After Delimiter" = Table.AddColumn(Source, "Fase", each Text.AfterDelimiter([FaseID], " "), type text),
#"Inserted Text Before Delimiter" = Table.AddColumn(#"Inserted Text After Delimiter", "Sortering", each Text.BeforeDelimiter([FaseID], "."), Int64.Type)
in
#"Inserted Text Before Delimiter"
When the query is loaded I get an error message, but when I try to view errors, none are found.
If the datatype is changed in a seperate step, it works as expected.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.