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.
Hello everyone.
I'm trying to put together a composite key between two fields from the query editor. But it returns error, and I am using the correct syntax.
For example, I have two fields "date" and "market".
Formula: [Fecha] & " " & [Market]
Expression: = Table.AddColumn(#"Columnas quitadas1", "Key", each [Fecha] & " " & [Market])
Expression.Error: The & operator can not be applied to the Date and Text types.
Details:
Operator=&
Left=1/4/2018
Right=
How can I join two fields of different types for the composite key?
Thanks!
Solved! Go to Solution.
Hi @gabrielvigo,
Try it like this:
Table.AddColumn(#"Changed Type", "key", each [Market] & " " & Text.From([Fecha]))
Best Regards,
Dale
Hi @gabrielvigo,
Try it like this:
Table.AddColumn(#"Changed Type", "key", each [Market] & " " & Text.From([Fecha]))
Best Regards,
Dale
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |