Forum Discussion

Mehul's avatar
Mehul
Frequent Visitor
3 years ago
Solved

New table with distinct column with max index value

I have a table the following table.   Name.     Index.       Level             Project  A              1              Level1            ALPHA B               2             Level2            ALPHA...
Need Help
  • themistoklis's avatar
    themistoklis
    3 years ago

    Mehul 

     

    Create a new table (Home Menu --> Modelling --> New Table) and add the following DAX formula:

    Grouped Table =
    CALCULATETABLE (
        SUMMARIZE ( Sheet1, Sheet1[Name], "MaxIndex", MAX ( Sheet1[Index] ) ),
        Sheet1[Level] = "Level2"
    )

     

    PowerBI workspace attached

     

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
3 years ago

Mehul 

 

Create a new table (Home Menu --> Modelling --> New Table) and add the following DAX formula:

Grouped Table =
CALCULATETABLE (
    SUMMARIZE ( Sheet1, Sheet1[Name], "MaxIndex", MAX ( Sheet1[Index] ) ),
    Sheet1[Level] = "Level2"
)

 

PowerBI workspace attached