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,
I cannot use join to get my expected outcome since rows has no primary key which are matching.
What I have:
Table A
Date | Day | |
16.01.2023 | Monday | |
17.01.2023 | Tuesday | |
18.01.2023 | Wednesday | |
19.01.2023 | Thursday | |
20.01.2023 | Friday |
Table B
Task | ID | |
Mount | 1 | |
BUY | 2 | |
FETCH | 3 |
How to get this table:
Date | Day | Task | ID | |||
16.01.2023 | Monday | Mount | 1 | |||
16.01.2023 | Monday | BUY | 2 | |||
16.01.2023 | Monday | FETCH | 3 | |||
17.01.2023 | Tuesday | Mount | 1 | |||
17.01.2023 | Tuesday | BUY | 2 | |||
17.01.2023 | Tuesday | FETCH | 3 |
Thank you very much in advance.
Best.
Solved! Go to Solution.
>>Table A >> Add Custom Column >> With Below Code And Pic.
>> After Create Column >> Expand Table Column >> With Need You Column.
M Code : #"Table B"
@Applicable88 If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.
I am trying to do this exact thing, but the accepted solution doesn't work because I can't complete the step in the first picture. The system greys out the "OK" button and displays an error. But clicking "Show error" does nothing. Any idea what I should do?
That worked. Thanks.
>>Table A >> Add Custom Column >> With Below Code And Pic.
>> After Create Column >> Expand Table Column >> With Need You Column.
M Code : #"Table B"
@Applicable88 If this post helps, please consider accept as solution to help other members find it more quickly and Appreciate your Kudos.
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.