Forum Discussion
Learner86
Helper I
Helper IDelete rows and groupby
Dear community, how can I solve the following problem: Username Typ Costs Frequency Index Musterman M 125 6 1 Musterman M 3200 6 2 Musterman M 3200 6 3 Musterman...
in dax:
new table=filter(table1,VAR _max=calculate(max(table1[costs]),allexcept(table1,table1[username],table1[typ])) RETURN table1[costs]=_max)
wdx223_Daniel
Community Champion
Community Championin dax:
new table=filter(table1,VAR _max=calculate(max(table1[costs]),allexcept(table1,table1[username],table1[typ])) RETURN table1[costs]=_max)
Learner86It works, thank you very much wdx223_Daniel