MAXX in M Function

[Anonymous]

Hi folks,

I`m trying to ADD a TRUE of FALSE column based on two columns with PowerQuery Functions: 

It`s in DAX =IF('Projetos em Andamento'[Id]=MAXX(FILTER('Projetos em Andamento';'Projetos em Andamento'[Project Name (Jira)]=EARLIER('Projetos em Andamento'[Project Name (Jira)]));'Projetos em Andamento'[Id]);TRUE())

But i need it in M (PowerQuery).

Please help me!!!

[HotChilli · Accepted solution]

So you want a TRUE value for the highest ID per Project Name?

Duplicate the query.

Do a Group By-> using Project Name and MAX on the ID.

This will give you a table with the highest id for each project

project name    id

Squad                7

Portal                 9

......

Add a custom column "TRUE"

Merge this table with the original table using a Left Join (from the original)

This will get you:

then you replace the null values with FALSE