So this then?

SELECT pf ,

Data ,

Descr,

ROW_NUMBER() OVER (PARTITION BY pf ORDER BY Data DESC,idAuxiliarPF DESC)

FROM dbo.PFAuxiliar PFA1

WHERE Data <= GETDATE()

AND Descr IS NOT NULL