Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

Power BI and BC Data consolidation

(0) ShareShare
ReportReport
Posted on by 338

Hi there,

I have this data set with values in my differents columns that belong to same Dimension Set ID, is there any way I can consolidate this data in one single row?

This is what I have:

Dimension_Set_ID AREADEPTO ZONA TIPO CTE FAMILIA LINEA
3 MAYORISTA
3 Sup Ciudad de México
3 GUERRA RICARDO

This is what I want:

Dimension_Set_ID AREADEPTO ZONA TIPO CTE FAMILIA LINEA
3 Sup Ciudad de México GUERRA RICARDO MAYORISTA

 I'm trying to achive this with Power BI, is that possible? 

Could you point me to right direction?

TIA

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans