Forum Discussion
Distinc date wise value
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.
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
3 Replies
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
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
