Forum Discussion

hasharma19's avatar
hasharma19
Helper II
1 year ago
Solved

Power Query Duplicating rows(twice/trice)

Hi All, I have a excel file, haveing multiple sheets(Jan, Feb..ect) with some tasks assigned to team. If specific person completed the task i am caturing Done aganist the task and X for imcomplete/...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    1 year ago

    Hi hasharma19 
    It seems that there are merged tables cause the duplicating.
    You can concatenate the name with the month and remove duplicates from PQ.

    Result :

    The pbix is attached

    *The merged step can be removed, the steps of PQ will repeat themselves every refresh

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Ritaf1983's avatar
Ritaf1983
Super User
1 year ago

Hi hasharma19 
It seems that there are merged tables cause the duplicating.
You can concatenate the name with the month and remove duplicates from PQ.

Result :

The pbix is attached

*The merged step can be removed, the steps of PQ will repeat themselves every refresh

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.