Last seen: Jul 8, 2026
Keep in mind that when you concatenate values like 229/057 & 25, you create a text "229/05725". Compare that to 229/057 & 5 which becomes the ...
Perhaps you accidentally unchecked the option to "Include new rows and columns in table", under File, Options, Proofing, AutoCorrect Options. That res...
Perhaps not the most elegant solution but I had an older model that calculated FIFO cost and adapted it a little to be used with your example. Star...
Try by adding two columns using Text.Select. Once to keep only letters A to Z. Another to keep 0-9, the dollar sign and the decimal point. Then you ca...
As a variant: let Source = Excel.CurrentWorkbook(){[Name="myData"]}[Content], Headers = Table.PromoteHeaders(Source, [PromoteAllScalars=tru...