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 & wei...
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
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