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 have a date table. I have another table having two columns - ID and category for each id. I want to create a new table which will have 2 columns - Date series from date table and ID. Following are the issues i am trying to resolve:
1) How to create the new table bringing in date series and id from the two other tables.
2) Date Series in the 1st column will repeat for each id
I have shown below a sample of two tables along with the desired output table:
1) 1st Input - Date Table:
EOM Dates |
01/31/2023 |
02/28/2023 |
2) 2nd Input - ID Table:
ID |
501 |
502 |
3) Output Table
EOM Dates | ID |
01/31/2023 | 501 |
02/28/2023 | 501 |
01/31/2023 | 502 |
02/28/2023 | 502 |
Solved! Go to Solution.
Hi @RahulKumarBIT after you imported your data, new table should be:
Proud to be a Super User!
Hi @RahulKumarBIT after you imported your data, new table should be:
Proud to be a Super User!
User | Count |
---|---|
53 | |
46 | |
19 | |
16 | |
13 |
User | Count |
---|---|
108 | |
56 | |
29 | |
21 | |
18 |