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, I have a little problem expanding table after a merge
So here have three visualizations
As you can see two record records match on the highlighted columns, but no rows in the Merge1 table.
This is how I got to this result.
= Table.NestedJoin(All,{"cec_upn", "dx_dte", "Index"},Col,{"cec_upn", "dx_dte", "Index"},"Col",JoinKind.Inner)
All good sofar.
I then did
= Table.ExpandTableColumn(Source, "Col", {"cec_upn", "colorectal_case_cde", "dx_dte", "icd3_cde", "Index"}, {"Col.cec_upn", "Col.colorectal_case_cde", "Col.dx_dte", "Col.icd3_cde", "Col.Index"})
v
Everything was done thru the UI.
Can you explain why I get an empty table.
Thanks Fred
Solved! Go to Solution.
Hi Fnoorda,
I have test your issue, and it works after I merged two tables:
One possible condition in your case is that the data type of columns in table All doesn’t match the data type of columns in table Col. Please check if data types of columns are same in two tables.
Please refer to my PBIX file: https://www.dropbox.com/s/clyn58d40vpphtn/For%20Fnoorda.pbix?dl=0
Best Regards,
Jimmy Tao
Hi Fnoorda,
I have test your issue, and it works after I merged two tables:
One possible condition in your case is that the data type of columns in table All doesn’t match the data type of columns in table Col. Please check if data types of columns are same in two tables.
Please refer to my PBIX file: https://www.dropbox.com/s/clyn58d40vpphtn/For%20Fnoorda.pbix?dl=0
Best Regards,
Jimmy Tao
Thanks Jimmy that does solve the problem. Thanks for your help. Powerbi does seem to change the data type sometimes from whatever it is to this "any type" I asume that equtes to variant.
Thanks again.
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 |
---|---|
112 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |