Forum Discussion
jhendrickson
8 years agoRegular Visitor
Create a Calculated Column from Different Tables
I am attempting to add a column to a table in the Query Editor, using a column from a related table. I am getting an error "Token literal expected." The relationship between these tables has been set...
- 8 years agoSorry that's my bad. I happen to work on a French system and it is using ";" rather than comma ",".
You need to replace all ";" by the proper separator which should be comma for you.
v-ljerr-msft
8 years agoMicrosoft Employee
Hi jhendrickson,
Could you post your real table structures(including the relationships) with just some sample/mock data, and the expected result? So that we can further assist on this issue? It's better that you can just share a sample pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:
Regards
jhendrickson
8 years agoRegular Visitor
https://www.dropbox.com/l/scl/AAC88asXaxFoogfp3MGpSW2R6A-TPrTFxAU
This is a very truncated version of my data - thank you everyone for your help!