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.
Hi
I am wondering if someone can help,
I have a table that has Product ID 1 and Product ID 2 (they both link to the same product)
I have a also have a Date Table.
I want to be able to merge them together so that every date within the date table has Product ID 1 & 2 beside them
Is this possible?
Thanks in advance,
Boycie92
Hi @Boycie92,
Could you post your table structures with some sample/mock data, and the expected result against the data? So that we can better assist on this issue.
Regards
@Boycie92 may i ask what you are trying to achieve exactly? you could create a conditional calculated ID column and give ita new id where its product 1 or 2, but it would be helpful to know what you want to do?
for example
Proud to be a Super User!
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 |
---|---|
87 | |
78 | |
62 | |
61 | |
59 |
User | Count |
---|---|
160 | |
114 | |
100 | |
74 | |
65 |