Forum Discussion

BIswajit_Das's avatar
BIswajit_Das
Impactful Individual
3 years ago
Solved

Power bi Create table DAX

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

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

    Anyway Thanks for responding.

  • BIswajit_Das's avatar
    BIswajit_Das
    3 years ago

    Found a solution :-

    NewTable = FILTER(
                   SUMMARIZE('Table', 'Table'[MOB], "Name", MAX('Table'[Name])),
                   NOT(ISBLANK('Table'[MOB]))
               )
BIswajit_Das's avatar
BIswajit_Das
Impactful Individual
3 years ago

Found a solution :-

NewTable = FILTER(
               SUMMARIZE('Table', 'Table'[MOB], "Name", MAX('Table'[Name])),
               NOT(ISBLANK('Table'[MOB]))
           )