Forum Discussion
fedeleu
4 years agoFrequent Visitor
Problems with Table.Distinct
Hi! I have the following code let Origen = Table.Combine({Unico2020, Unico2021}), #"Filas filtradas" = Table.SelectRows(Origen, each ([Titolare] = "Empresa")), #"Tipo cambiado" = Tab...
fedeleu
4 years agoFrequent Visitor
That worked!
Thank you very much!!!
Can you explain me what Table.Buffer does?
KNP
Super User
4 years agoIt stores the table in memory preventing that step from being evaluated again. Typically used for performance improvements.
I think the reason this is needed in the sorting/distinct scenario is best explained in this post...
https://exceleratorbi.com.au/remove-duplicates-keep-last-record-power-query/