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]))
               )

3 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi BIswajit_Das 

    with the data shown, you can try like:

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

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

    Found a solution :-

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