Using M to show the last record

[Rigolleto]

Hi,

I need to filter and show the last record from the list, I need to do it in power query using M, anybody can help!!!

[Anonymous · Accepted solution]

@Rigolleto - You could Add a Custom Column that indicates whether the row equals the max index, like this:

if [Index] = List.Max(#"Added Index"[Index]) then "Yes" else "No"

Note: #"Added Index" is the name of the previous step in my case. You'll need to use the name of your previous step.

Then, you can filter on your new column to only include "Yes".

Hope this helps,

Nathan

[Anonymous]

M does not have the concept of ordering of rows, so "last" is not working. I would say that you need a "max", and then you can click on the arrow, sort by value descending and the filter just one row