Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

MAXX in M Function

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 ...
Need Help
  • HotChilli's avatar
    HotChilli
    7 years ago

    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

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
7 years ago

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