Returns only first row with lookupvalue

Hello Laufer_Israel 

if you need to do this in Power Query, use this slightly changed query

let
	Source = #table
	(
		{"Code","Name","Product","Quantity","Total sales 2018"},
		{
			{"1","One","PP","2","220"},	{"1","One","SS","3","220"},	{"1","One","YY","4","220"},	{"1","One","MM","9","220"},	{"2","Two","PP","1","167"},	{"2","Two","SS","4","167"},	
			{"2","Two","YY","7","167"},	{"2","Two","MM","2","167"},	{"3","Three","PP","3","701"},	{"3","Three","SS","1","701"},	{"3","Three","YY","3","701"},	{"3","Three","MM","8","701"}

					}
	),
    ChangeType = Table.TransformColumnTypes(Source,{{"Code", Int64.Type}, {"Name", type text}, {"Product", type text}, {"Quantity", Int64.Type}, {"Total sales 2018", Int64.Type}}),
    Group = Table.Group(ChangeType, {"Code", "Name", "Total sales 2018"}, {{"AllRows", each _, type table [Code=number, Name=text, Product=text, Quantity=number, Total sales 2018=number]}}),
	AddIndex = Table.TransformColumns
	(
		Group,
		{{"AllRows", each Table.AddIndexColumn(_,"Index",1 )}}
	),
	AddColumn = Table.TransformColumns
	(
		AddIndex,
		{{"AllRows", each Table.AddColumn(_,"Total Sales 2018 new",(add)=> if add[Index]=1 then add[#"Total sales 2018"] else null )}}
	),
    DeleteOtherColumns = Table.SelectColumns(AddColumn,{"AllRows"}),
    ExpandAllRows = Table.ExpandTableColumn(DeleteOtherColumns, "AllRows", {"Code", "Name", "Product", "Quantity", "Total sales 2018", "Total Sales 2018 new"}, {"Code", "Name", "Product", "Quantity", "Total sales 2018", "Total Sales 2018 new"})
in
    ExpandAllRows

Copy paste this code to the advanced editor to see how the solution works

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy