Forum Discussion
Conditional Statement not having expected behavior
Anonymous - quick workaround is by changing the data type of version column to Date and you will get a comparable column as shown below and then you use a conditional column.
If this post helps to find solution would be happy if you could mark my post as a solution and give it a thumbs up
Best regards
Manoj Nair
Linkedin - https://www.linkedin.com/in/manoj-nair-%E2%98%81-344666104/
Hi Anonymous - your intuition is correct. When Alphanumeric ordering occurs the 6 is greater that 11 because the 6 is compared to the first character. I would suggest trying to format the number by adding leading zeros. For example, convert from "8.2.11" to "08.02.11".
Try using:
Text.Split - PowerQuery M | Microsoft Learn
List.Transform - PowerQuery M | Microsoft Learn
Text.PadStart - PowerQuery M | Microsoft Learn
Text.Combine - PowerQuery M | Microsoft Learn
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WstAz0jNTitWBsAwNwUxDYz0QUoqNBQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Added Custom" = Table.AddColumn(Source, "New Column", each
Text.Combine(
List.Transform(
Text.Split( [Column1], "." ),
each Text.PadStart( _ , 2 , "0" )
)
, ".")
, type text)
in
#"Added Custom"