Reply
Visitor
Posts: 1
Registered: ‎04-24-2018
Accepted Solution

Compressing Duplicate Records

Hello,

 

Apoligies if this is a fairly trivial question, I'm quite new at Power BI.

 

Is there anyway to remove duplicate columns automatically without losing any data? i.e have my dataset compress all ID's of EX1 into one row instead of multiple. The ID's that I'm using may be repeated due to connections with other columns, but I'm not concerned about that, I'm looking to just get an aggregate for each day. Example:

 

ID - Store - Total Sales

EX1 - Store 1 - 10

EX1 - Store 2 - 10

 

I would like it to just be:

 

ID - Sales

EX1 - 20

 

I know this is likely easier to just format outside of Power BI, but I'm curious if it's possible to have done in Power BI.

 

Thanks in advance, 


Accepted Solutions
Community Support Team
Posts: 2,494
Registered: ‎02-06-2018

Re: Compressing Duplicate Records

Hi Labossi,

 

Your data is changing everyday and you want to see the aggregation of data everyday, right?

 

You don't need to change data in data model(e.g.:remove some columns), just drag Total Sales column and ID column into a table chart, then click Total Sales in Values pane -> select Sum

0.PNGCapture.PNG2.PNG 

 

Regards,

Jimmy Tao

View solution in original post


All Replies
Member
Posts: 66
Registered: ‎01-29-2018

Re: Compressing Duplicate Records

In QueryEditor, delete the Store column, close and load.

 

Unless I'm not understanding your needs, this should work

Community Support Team
Posts: 2,494
Registered: ‎02-06-2018

Re: Compressing Duplicate Records

Hi Labossi,

 

Your data is changing everyday and you want to see the aggregation of data everyday, right?

 

You don't need to change data in data model(e.g.:remove some columns), just drag Total Sales column and ID column into a table chart, then click Total Sales in Values pane -> select Sum

0.PNGCapture.PNG2.PNG 

 

Regards,

Jimmy Tao