Forum Discussion
Community ChampionHelp with Calculated Table
Hi rsbin
This would be probably best done in PQ but if you want it in DAX:
NewTable = FILTER ( Table1, Table1[EndID] = CALCULATE ( MAX ( Table1[EndID] ), ALLEXCEPT ( Table1, Table1[Emp ID] ) ) )This will keep the EndID in the table. If you want it out you can use SELECTCOLUMNS
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Community ChampionHi rsbin
This would be probably best done in PQ but if you want it in DAX:
NewTable =
FILTER (
Table1,
Table1[EndID] = CALCULATE ( MAX ( Table1[EndID] ), ALLEXCEPT ( Table1, Table1[Emp ID] ) )
)
This will keep the EndID in the table. If you want it out you can use SELECTCOLUMNS
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Community ChampionAlB, Jihwan_Kim ,
Thank you both for the responses. I am working in an SSAS model, so I cannot use PQ - need it in DAX.
I was attempting Jihwan's solution, but it looks like TREATAS is not a valid function.
I am now attempting AIB's solution - looks to be much simpler.
Thanks kindly to you both. Will let you know how it works out.