Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Expanded columns showing duplicate numbers total, remove duplicate and still show true data

Hi Everyone, 

 

I am using a sharepoint list with a column set to Choice. 

 

When the date is imported to PowerBI it did not like it and showed [List]

 

I expanded the column but now the list is showing duplicate titles because of the Choice. 

 

The total amount is not true because it is counting the duplicate as well. 

 

How do I show the REAL total amount?

 



Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous 

    Can you provide some sampel data so that can provide more suggestion for you, the message you have offered is little, if you want to remove the reprated data, you can remove them in power query by using delete the  duplicate rows.

     

    Best Regards!

    Yolo Zhu