Power bi Create table DAX

[BIswajit_Das]

Hello Guys,

I have a table like

and i want to create a table with summerise data

For example :-

er         Name

93127   Tulashi

99098   Sudhanshu

63140   Ananta

Thanks

[BIswajit_Das · Accepted solution]

The Column "re" is actually mobile numbers so is this query gonna work ?

Anyway Thanks for responding.

[BIswajit_Das · Accepted solution]

Found a solution :-

NewTable = FILTER(

               SUMMARIZE('Table', 'Table'[MOB], "Name", MAX('Table'[Name])),

               NOT(ISBLANK('Table'[MOB]))

           )

[FreemanZ]

hi @BIswajit_Das 

with the data shown, you can try like:

Table =
ADDCOLUMNS(
VALUES(TableName[er]),
CALCULATE(MAX(TableName[Name]))
)

[BIswajit_Das · Accepted solution]

The Column "re" is actually mobile numbers so is this query gonna work ?

Anyway Thanks for responding.