Merge Multiple Rows Into One

[Akers]

Hi,
We are trying to put together a report in Power BI Desktop using data from SQL Server, we are having issues with duplicate values.

The above screenshot shows the problem, we have a job with the same order number where multiple tasks have been completed but one overall price. what we need to achieve is something like the below.

Essentially, we need to see the cost only once for each job number.

Any help on how we could achieve this would be appreciated.

[v-piga-msft · Accepted solution]

Hi @Akers ,

For your scenario, you may could try to create a calculated table with SUMMARIZE to achieve that. Please refer to the formula below.

table= summarize('table name',"order numer","jobDate",...)

If you still need help, please share some data sample with table format and your desired output so that people could make a copy and have test.

Best Regards,

Cherry

[v-piga-msft]

Hi @Akers ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share your data sample with table format and your desired output so that we could copy and test on it.

Best  Regards,

Cherry

[jdbuchanan71 · Accepted solution]

Give this a try

Descriptions = IF ( ISINSCOPE ( Ordernumber ), CONCATENATEX ( Table, Table[Job Description],", ")

You will need to replace the "Table" with whatever your table name is.  The ISINSCOPE keeps the string from building on total rows.

[v-piga-msft · Accepted solution]

Hi @Akers ,

For your scenario, you may could try to create a calculated table with SUMMARIZE to achieve that. Please refer to the formula below.

table= summarize('table name',"order numer","jobDate",...)

If you still need help, please share some data sample with table format and your desired output so that people could make a copy and have test.

Best Regards,

Cherry