Forum Discussion

ThomasWeppler's avatar
ThomasWeppler
Icon for Impactful Individual rankImpactful Individual
1 year ago
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...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    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.

     

ThxAlot's avatar
ThxAlot
Icon for Super User rankSuper User
1 year ago

From your description, it seems ([User_id], [Date]) can be used as "composite key"; thus

= COUNTROWS( SUMMARIZECOLUMNS( WorkPlanEntry[User_id], WorkPlanEntry[Date] ) )