Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
Hoping for some guidance here. I am trying to merge 2 tables together in Power Query using a text field to do the join. When I do an inner join I get an error saying "DataFormat.Error: We couldn't conver to Number. Details: 6/27/2020". No where in either table am I trying to convert a date field to a number so I have no idea where this is coming from. Additionally when I do a left or right join with the same tables I don't get an error.....
Has anyone run into a similar issue.
Thanks
Hi @Anonymous
Kindly change the data type to text. before you do the inner join
I already did that in a previous step..
I'd double check that after the join it's not tried to put in an automatic changed type row first
Any guidance on how I can do that?
When I do to look in the advanced editor for the new query after the merge this is all I can see..
let
Source = Table.NestedJoin(COMBINED_SALES_DATA, {"Commission Customer Number"}, #"Customer Number to ED Agent", {"Customer Number"}, "Customer Number to ED Agent", JoinKind.Inner)
in
Source
and output of the query just shows this
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |