Forum Discussion
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
The Column "re" is actually mobile numbers so is this query gonna work ?
Anyway Thanks for responding.
Found a solution :-
NewTable = FILTER(SUMMARIZE('Table', 'Table'[MOB], "Name", MAX('Table'[Name])),NOT(ISBLANK('Table'[MOB])))
hi BIswajit_Das
with the data shown, you can try like:
Table =
ADDCOLUMNS(
VALUES(TableName[er]),
CALCULATE(MAX(TableName[Name]))
)
The Column "re" is actually mobile numbers so is this query gonna work ?
Anyway Thanks for responding.