Forum Discussion
Solved
Data transformation with calculation with M
Hi, I have a connection to a SQL Server Instance importing a over million rows table on which I want to perform a simple manipulation on some data before import, but I don't know if this is possible...
maclura
You need to group and a little custom column to get it. Please check the attached file below my signature.
Thank you Fowmy
Your suggested solution does work with me.
I'd never used the Table.ReplaceValue function.
I have just an additional question which is more curiosity than other.
In your code I read this line
= Table.Group(#"Changed Type1", {"Item"}, {{"Count", each Table.RowCount(_), Int64.Type}, {"Max", each List.Max([Cost]), type nullable number}, {"All", each _, type table [Item=nullable text, Cost=nullable number]}})instead, when I recreated the same using the 'Group by' widzard, this is what I read:
= Table.Group(#"Changed Type1", {"Item", "Cost"}, {{"Count", each Table.RowCount(_), Int64.Type}, {"Max", each List.Max([Cost]), type nullable number}, {"All", each _, type table [Item=nullable text, Cost=nullable number]}})why?