I think what you want to do is create a slice on you table. The slice will filter the table to only include a single row per company. You don’t so much care which row of a company is included, just that there is exactly one row per company. The slice filter you want is something like this:
([_THISROW] = MAXROW("MyTable", "_ROWNUMBER", ([_THISROW].[Company] = [Company])))
MyTable with the name of the table.
As @Bellave_Jayaram suggests, though, the row numbers may not truly reflect the chronological order in which the rows were added (for instance, if you’ve manually sorted the worksheet, or of you’re using a database rather than a spreadsheet). If you specifically want the newest row and the table has some sort of timestamp column that can identify the newest row, you would do well to use the timestamp rather than the row number:
([_THISROW] = MAXROW("MyTable", "Timestamp", ([_THISROW].[Company] = [Company])))
Timestamp with the name of your timestamp column.