Compressing Duplicate Records

[Labossi]

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, 

[v-yuta-msft · Accepted solution]

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

 

Regards,

Jimmy Tao

[Yggdrasill]

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

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