Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
My TAB BRAND ,Table 1 working fine :-
MY TAB COY , TABLE 2 WORKING FINE :-
Can some one share with me how to combine table 1 and table 2 into one table ?
My sample PBI :-
https://www.dropbox.com/s/neiaj147r3hft53/SAMPLE_1000_SI_TI_V026.pbix?dl=0
Paul
Hi @admin11 ,
Please check the link to your sample PBI. There is no file in it.
Are you trying to get the results of two tables combined and sorted by account. I think the best way is combine all the underlying data firstly, after that, get a rank for them.
Best Regards
Community Support Team _ chenwu zhu
Hi @admin11 ,
There are two ways to do it:-
1. Append table 1 into table 2 in the power query
2. Or you can create a new table with below code:-
Table = UNION(s_ummrizeTable1,s_ummrizeTable2)
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Thank you for your sharing. appreciate very much.
In my actual application , it have total 5 s_ummarize_Table.
I thinking the issue may be cause by rank field need to link up. i try , but i still unable to figure out how to link . As this is a sample PBI file.
Below expression may be have some issue . it should be auto switch Rabk , but seen like it does not work :-
Paul
i just posted below post , which i explain very detail , hope you can help me :-
Paul
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
104 | |
87 | |
73 | |
66 |
User | Count |
---|---|
122 | |
112 | |
98 | |
79 | |
72 |