Forum Discussion
Helper VJoin multiple values to a single value
Hi,
I have a CROSSJOIN -type of a problem i can't seem to solve. The situation is presented below. I want to join multiple milestones to a single task. For example, Task 2 has Milestones 2,3, and 4 attached to it. Is it possible to create a calculated table like this?
Hi CarlsBerg999 ,
Try using merge queries in the query editor.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
CarlsBerg999 , Have tried full outer join merge in power query?
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Various DAX joins
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
V-lianl-msftCommunity Support
Hi CarlsBerg999 ,
Try using merge queries in the query editor.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
