I have one column which is in table A.
I have one column which is in table B.
ID |QRC| QRF| SRC| SRF| MRC| MRF
EDIT: This is just an example, In real scenario, each column contains more than 40+ values.
I want this output scenario to happen automatically in column, not dynamically using transpose function.
Solved! Go to Solution.
Yes, this is what I want, but I see you have converted it to columns using transpose and have selected each and every column to keep it in place,
But the question was an example, In future case I can have more than 40+ values in each column so instead of dynamically selecting that column, I want that it should happen automatically, all the column values should be shown as output columns without transposing it into various columns and selecting it.
Thanks for the help,
I saw that column names are different, and I cannot change column names due to permission issues. and I edited the post accordingly.
not quite understand this request. you said column names are different in the previous post. what's the problem you are facing after you used the solution i provided?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.