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?
