Solved: Re: Distinc date wise value

Anonymous · ‎03-27-2022

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 · ‎04-05-2022

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

View solution in original post

Anonymous · ‎04-05-2022

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 · ‎03-27-2022

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

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany