Forum Discussion

DataAnalysis's avatar
DataAnalysis
Frequent Visitor
4 years ago
Solved

Problems with duplicate data processing after a separate column

Hello. I use PowerBI in Korea. Recently, I've been doing a lot of different things since I started using PowerBI. There is a recent issue, and I am writing here to ask for your advice. There is d...
Need Help
  • ribisht17's avatar
    ribisht17
    4 years ago

    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"