Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Columns association in query editor

Hi all,

 

I'm facing an issue in the query editor.

Cado_0-1623742674419.png

 

On the above screenshot, the referents in the referent column are associated with the IDs of the id column. And the measurements of the measures column are associated with the IDs of the id.1 column.

IDs from both id columns are the same but not in the same order.

My wish is to have the referents associated with the ids of the id.1 column, without using separate tables and then merge tables (because I'm restricted by API limitations).

 

How would you do that ?

 

Thanks in advance,

Cado

1 ACCEPTED SOLUTION
Cado_one
Resolver III
Resolver III

After some work on it, a solution was to add a custom column taking for value 1 if id.1=id else 0 and then filter on it to keep only the 1.

View solution in original post

3 REPLIES 3
Cado_one
Resolver III
Resolver III

After some work on it, a solution was to add a custom column taking for value 1 if id.1=id else 0 and then filter on it to keep only the 1.

amitchandak
Super User
Super User

@Anonymous , Copy this table, remove the first two-column, Remove duplicates for the remaining two-column  this will be table2

 

From Table1 , remove columns 3,4, if needed remove duplicates.

 

Merge these two tables now by matching id1. and id

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Anonymous
Not applicable

Hi @amitchandak 

 

As I said in the first message I can't duplicate the table because it will do extra queries and the API limitations don't allow this.

I can't reference neither because their are subsequent steps that delete the IDs columns and more over, references are forbiden for the automatic refresh in the Power BI Service.

Is there an other way to proceed ?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.