duplicate

6 Topics

DAX - Rank duplicates in sequence
Hi experts group, I have searched the forum, but can't find the solution on my issue. I need your help to write DAX code on how to rank the duplicates in sequence. This is the data and I'd like to achieve the result as below in Count Duplicate column Type Count duplicate a 0 a 1 b 0 c 0 b 1 c 1 c 2 a 2 The aim is to keep the 1st duplicates and remove the rest of duplicates using filter. Thank you.
Solved
vanvir
2 years ago Place DAX Commands and Tips
745Views
0likes
2Comments
Calculation Involving Duplicates
Without deleting duplicates, how do I write a formula to calculate the total scrap percentage by date? Scrap% = (Machine Scrap/(Machine Scrap + Good Quantity)) * 100 Production Day Machine Scrap Good Quantity 06/01/2023 12:00:00 AM 33103 734164 06/01/2023 12:00:00 AM 33103 734164 06/01/2023 12:00:00 AM 33103 734164 06/01/2023 12:00:00 AM 33103 734164 06/01/2023 12:00:00 AM 33103 734164 06/01/2023 12:00:00 AM 33103 734164 06/01/2023 12:00:00 AM 33103 734164 06/01/2023 12:00:00 AM 33103 734164 06/01/2023 12:00:00 AM 33103 734164 06/01/2023 12:00:00 AM 33103 734164 06/01/2023 12:00:00 AM 33103 734164 06/01/2023 12:00:00 AM 29452 744589 06/01/2023 12:00:00 AM 29452 744589 06/01/2023 12:00:00 AM 29452 744589 06/01/2023 12:00:00 AM 29452 744589 06/01/2023 12:00:00 AM 29452 744589 06/01/2023 12:00:00 AM 29452 744589 06/01/2023 12:00:00 AM 29452 744589 06/01/2023 12:00:00 AM 29452 744589 06/01/2023 12:00:00 AM 29452 744589 06/01/2023 12:00:00 AM 29452 744589
Anonymous
3 years ago Place DAX Commands and Tips
1.8KViews
0likes
9Comments
Find duplicates between "date selected" and "date selected" - 30 days
Hi! 🙂 I have date filters (slicer) for year, month and day in a model that uses a table with [ID] and [Date] I want to show the duplicates between the "Date selected" and ("Date selected" -30 days) This is the table: If i select "December 1st, 2022" it should only show these: Thank you!
JayV
3 years ago Place DAX Commands and Tips
1.1KViews
0likes
3Comments
RankX Ranking same values as same rank
Good Day, I am getting duplicate rankings when they have the same value. In this case its zeros. Is there a way to get it to represent 1,2 and 3 instead of 1,1,1? Pro Audit Rank = RANKX(ALL(System_Users),Audit[SUM Pro Audit])
Anonymous
3 years ago Place DAX Commands and Tips
792Views
0likes
3Comments
How to create a new table with duplicate dates and values from an existing table
I have these two tables - with no natural connection: And I want to create this table for all the dates with DAX, please help!
Solved
Anonymous
3 years ago Place DAX Commands and Tips
680Views
0likes
2Comments
Union two tables and no duplicate the rows when date updated
Hi All, I am new to PowerBi, I need your help please. I have two tables (TABLE1, TABLE2) that i want to union: TABLE 1 Client PartNo Titre TYPE Start Date projected End Date projected Real End Date Projet Name ClientXX AAAA Tool Prove NPI 09/03/2021 22/03/2021 21 mars 21 FA1 ClientXX AAAA Inspection NPI 09/05/2021 22/05/2021 FA1 ClientYY BBBB Methodes REV 09/04/2021 22/04/2021 FA1 TABLE 2 Client PartNo Titre TYPE Start Date projected End Date projected Real End Date Projet Name ClientXX AAAA Inspection NPI 09/05/2021 22/05/2021 23 mai 21 FA1 ClientYY BBBB Methodes REV 09/04/2021 22/04/2021 FA1 ClientXX CCCC Inspection NPI 10/04/2021 12/04/2021 FA2 The result I want after union (TABLE1; TABLE2) is like below: Client PartNo Titre TYPE Start Date projected End Date projected Real End Date Projet Name ClientXX AAAA Tool Prove NPI 09/03/2021 22/03/2021 21 mars 21 FA1 ClientXX AAAA Inspection NPI 09/05/2021 22/05/2021 23 mai 21 FA1 ClientYY BBBB Methodes REV 09/04/2021 22/04/2021 FA1 ClientXX CCCC Inspection NPI 10/04/2021 12/04/2021 FA2 But with DAX, i obtain the table below which keeps the row of TABLE1 and the row with date updated in column "Real End Date" of TABLE2 instead of keeping just row of TABLE2. Client PartNo Titre TYPE Start Date projected End Date projected Real End Date Projet Name ClientXX AAAA Tool Prove NPI 09/03/2021 22/03/2021 21 mars 21 FA1 ClientXX AAAA Inspection NPI 09/05/2021 22/05/2021 FA1 ClientXX AAAA Inspection NPI 09/05/2021 22/05/2021 23 mai 21 FA1 ClientYY BBBB Methodes REV 09/04/2021 22/04/2021 FA1 ClientXX CCCC Inspection NPI 10/04/2021 12/04/2021 FA2 Table = Var UnionTable=UNION(SELECTCOLUMNS('TABLE1';"Client";'TABLE1'[Client];"PartNo";"TABLE1"[PartNo];"Titre";'TABLE1'[Titre];"TYPE";'TABLE1'[TYPE];"Start Date projected";'TABLE1'[StartDate];"End Date projected";'TABLE1'[EndDate];"Real End Date";'TABLE1'[RealEndDate];"Projet Name";'TABLE1'[ProjName]);SELECTCOLUMNS('TABLE2';"Client";'TABLE2'[Client];"PartNo";"TABLE2"[PartNo];"Titre";'TABLE2'[Titre];"TYPE";'TABLE2'[TYPE];"Start Date projected";'TABLE2'[StartDate];"End Date projected";'TABLE2'[EndDate];"Real End Date";'TABLE2'[RealEndDate];"Projet Name";'TABLE2'[ProjName])) Return Groupby(UnionTable;[Client];[PartNo];[Titre];[TYPE];[Start Date projected];[End Date projected];[Real End Date];[Projet Name]) Anyone knows how to fix this problem ? Thanks!
Solved
Anonymous
5 years ago Place DAX Commands and Tips
6.6KViews
0likes
5Comments