Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
116 | |
107 | |
77 | |
70 |