Forum Discussion
Problems with duplicate data processing after a separate column
Please make use of Column Tool to create this formula instead
Custom Case2 = IF( ( RANKX (FILTER ('community_assist_duplicate (2)','community_assist_duplicate (2)'[Working Number]= EARLIER ( 'community_assist_duplicate (2)'[Working Number] )),'community_assist_duplicate (2)'[Working PLace],,ASC,DENSE)) =1,'community_assist_duplicate (2)'[Working Hours],"0")Regards,
Ritesh
"Please mark the answer if it helps you so that it can help others as well"
Thank you very much.
I answered Solved first, but can I ask you an additional question?
Thanks to your dedication, heat is generated without errors. When I enter your Formula in New Column in Column Tool, Column is created!!
However, one other error occurs.
"DAX comparison operations do not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values."
Case number is the Text type.
In the case of Active Hours, it is the Whole Number Type.
For MPC, the text type is not Number.
Since there are more than 10 locations, hexadecimal numbers A to F were also used to distinguish. Therefore, conversion to Whole Number is not possible...
If there is a problem, will it happen here?
Therefore, the following error occurs. What should I do?
When I converted the Actual hours to Text, all duplicate values were printed as they were.
I tried this and that in my own way, but suddenly I got a good output value.
Thank you so much!
It's thanks to you. I was really surprised by your technical skills.
Glad that it helped you, Cheers 🙂