Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Problem with duplicates

 

Hello, I need some help with data transformation. I have table like below:

 

And I need to have all data in one row for cases with new o revisit not blank. This is hard becouse there could be many revisits with te same id... My idea was to find first case assigned (or data suffucient or case done) date which is bigger than new case date  for each id, but i do not know how to implement that in power BI (i've tried vlookup bu it doesnt work becouse of duplicates)

 

Please help!

Need Help

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    7 years ago

    ImkeF might have some Power Query magic that could help with this. Can you provide your expected output from the data presented, I'm not sure I'm clear on exactly what you are going for. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi,

      I've extracted one of problematic cases in excel, this smaller table is my expected output.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Anonymous,

         

        It will be help if you share some sample data for test.

         

        You can direct paste sample data here with table formula or upload sample file to onedrive and share link here.

         

        Regards,

        Xiaoxin Sheng