Forum Discussion

AOT's avatar
AOT
Frequent Visitor
6 years ago

Summarising a column created duplicates

Hi,   I merged two tables in power query to create a table in the report.   This creates an issue when trying to summarize the qty column, i.e. sum(qty)   This is the unsummarised data t...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
6 years ago

I think after the merge the few rows are doubled. Or they are two and not visible in first visual. Filter both visuals on the first item and check(That item shows diff).

AOT's avatar
AOT
Frequent Visitor
6 years ago

Hi amitchandak 

 

I do not know know what you mean by filtering by the first item. It is the same visual (the same table).

 

It just produces different values when I summarize the QTY column.

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    put a filter of Atricle *60273282 and check how many rows each table gets