Date ID Name Company Country City Sales LastN Date ID Name Company Country City Sales 21/03/201816850307-6211 Felix Weiss Sem LLP Sierra Leone Feldkirchen in Kärnten 32638 6 28/09/201716550503-5773 Maxine D. Talley Ac Eleifend Vitae Foundation Iceland Piracicaba 16604 18/04/201816300905-7245 Maggy Z. Cruz Malesuada Augue Corp. Tonga CuracautÃ*n 42560 23/02/201916690717-4236 Colt Galloway Dolor Institute Myanmar Bella 22210 02/08/201716910128-2987 Melyssa Hale Mi Corporation Liechtenstein Temuka 18179 15/10/201716760516-8892 Lawrence Robertson Nec Malesuada Ut Corp. Morocco Cerchio 29323 19/01/201816340924-6224 Beau E. Colon Ultrices Iaculis Odio Corporation Kazakhstan Gouvy 33995 10/12/201716081122-7446 Rashad Witt Luctus Ipsum Corp. Andorra Stralsund 25673 01/06/201816490821-7609 Brenden Roach Nulla Aliquet PC Botswana Meerdonk 15790 20/04/201716370301-5291 Harding B. Leonard Ac Facilisis Facilisis Industries Bangladesh Petrópolis 41707 23/04/201716590903-0263 Ahmed U. Joyner Nec Cursus LLP Fiji Monte Patria 36711 26/02/201916820113-8164 Chanda Dudley Donec Egestas Institute Lebanon Blind River 20379 06/04/201916760811-7656 Signe Reilly Suspendisse Ac Metus Limited Uruguay Moorsel 27122 21/05/201716161112-9816 Candice G. Soto Enim Limited Cape Verde Juneau 30222 06/08/201816301111-8365 Casey N. Rivas Amet Limited Nicaragua Cartagena 12355 29/11/201816600616-1431 Bevis Whitney Pharetra Nibh Aliquam LLP Ukraine Oderzo 5335 12/01/201916960108-3315 Ralph D. Andrews Ultricies Ligula Corp. Angola Lives-sur-Meuse 10757 27/09/201716400628-3396 Cherokee Anthony Malesuada LLC Andorra Coaldale 24476 06/03/201916150805-6767 Zachary Stout Montes Nascetur Limited Austria Palma de Mallorca 21099 04/11/201816081021-5574 Ora Hill Duis At Company Sierra Leone Ollagüe 15549 26/02/201916611126-8857 Buffy B. Rosa Ac Orci Ut LLC Honduras Maizeret 16860 30/08/201716550804-4731 Blair Cooley At Risus Nunc Inc. Switzerland Erdemli 44575 11/05/201816880605-5177 Damian E. Saunders Convallis Est Vitae Industries South Sudan Saint-LŽger 26105 21/12/201716370909-7871 Daphne Z. Nguyen Commodo Ipsum Foundation Myanmar Poole 23005 02/08/201816650708-5287 Rina Chaney Mauris Inc. Botswana Luzzara 38850 14/05/201716520424-3629 Ivor Dudley Eget Ipsum Incorporated Congo (Brazzaville) Yerbas Buenas 34126 22/05/201816840222-8426 Nolan E. Park Dapibus Quam Incorporated Mali Pazarcık 35027 09/01/201816350412-2924 Chastity Lewis Eros Institute Christmas Island San Rafael 15116 08/01/201916091108-1446 Olivia K. Humphrey Massa Corporation Panama Moncrivello 25807 15/03/201816460829-8305 Ahmed F. Sherman Arcu Consulting Cape Verde Kelowna 20875 14/02/201916670528-1738 Oscar Franklin At Pretium Aliquet Inc. Ã…land Islands Fort St. John 35833
source is bigger so see attachmentCode:// Table1 let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], Counter = Table.FirstValue(Excel.CurrentWorkbook(){[Name="Table2"]}[Content]), Type = Table.TransformColumnTypes(Source,{{"Date", type date}, {"ID", type text}, {"Name", type text}, {"Company", type text}, {"Country", type text}, {"City", type text}, {"Sales", Int64.Type}}), LastN = Table.LastN(Type,if Counter=null then 0 else Counter) in LastN




Bookmarks