Distinc date wise value

[Anonymous]

Dear Brothers

My problem is that if any employee punch twice or more on a date my data table shows all the punch data but I need only one value of an ID in a date.

I have a table of id, dates & weights. Now I need Unique id wise only one weight of a day.

[Anonymous · Accepted solution]

Hi @Anonymous ,

You could create a new table by using distinct() function

https://docs.microsoft.com/en-us/dax/distinct-table-function-dax 

Table 2 = DISTINCT('Table')

Best Regards,

Jay

[TomMartens]

Hey @Anonymous ,

please keep in mind that there are also sisters.

Next, it's not clear if you want to remove rows from the table using Power Query or you need unique values for a certain calculation.

Please consider creating a pbix file that contains sample data, but still reflects your data model (tables, relationships, calculated columns, and measures). Upload the pbix to onedrive or dropbox and share the link. If you are using Excel to create the sample data share the xlsx as well.

Regards,

Tom 

[Anonymous]

Please check the raw data

https://docs.google.com/spreadsheets/d/1Sg6YmlKp-4rZBNsii-AkaJWvsMRqlUGt/edit?usp=sharing&ouid=11726...