Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello i have tried all possible options, can anyone help here ?
I am trying to CREATE NEW COLUMN, where if column N3 has duplicate in N2, returns 0, if no duplicated then return value from column I3.
I will highly appreciate your help. I am not trying to delete the duplicates i only need to to display 0 if duplicate.
Thank yo so much in advance, i have already few hours gone on searching the answer on that.
Viola
Solved! Go to Solution.
You may follow the steps below.
1) add an index column in Query Editor
2) add a calculated column in DAX
Column = IF ( RANKX ( FILTER ( Table1, Table1[WO_no.] = EARLIER ( Table1[WO_no.] ) ), Table1[Index], , ASC ) = 1, Table1[Duration_hour], 0 )
You may follow the steps below.
1) add an index column in Query Editor
2) add a calculated column in DAX
Column = IF ( RANKX ( FILTER ( Table1, Table1[WO_no.] = EARLIER ( Table1[WO_no.] ) ), Table1[Index], , ASC ) = 1, Table1[Duration_hour], 0 )
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |