Forum Discussion
Help 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.
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. |
AlB,
Working on modifying your proposed solution. There are other columns in the table that I need to disregard. Can you guide me as to how I would modify with SELECTCOLUMNS so that I grab only the columns that I need?
Edit: I think I figured out SELECTCOLUMNS:
=SELECTCOLUMNS(
FILTER(.....),
"column1", "column2," ... )
Thanks again and Kudos.