Forum Discussion
Solved
Removing duplicate rows based on three different columns
Hi Power BI community I have a table called WorkPlanEntry with all the workday that are planned for a company. My problem is that whenever a plan is edits the data added as a row in the table, bu...
ThomasWeppler , You can try creating new calculated table
LatestWorkPlanEntry =
SUMMARIZE(
'WorkPlanEntry',
'WorkPlanEntry'[User_id],
'WorkPlanEntry'[Date],
"LatestUniqueID", MAX('WorkPlanEntry'[Unique_id])
)This table will contain only the latest entries for each User_id and Date.
ThomasWeppler , You can try creating new calculated table
LatestWorkPlanEntry =
SUMMARIZE(
'WorkPlanEntry',
'WorkPlanEntry'[User_id],
'WorkPlanEntry'[Date],
"LatestUniqueID", MAX('WorkPlanEntry'[Unique_id])
)
This table will contain only the latest entries for each User_id and Date.
It worked like a charm.
Thanks bhanu_gautam for the quick answer.