Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Unanswered

Power BI and BC Data consolidation

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

Categories:

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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,552 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,552 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans