I have a table:
based on this I want to create a new table, which will assign employees to managers:
I tried with CROSSJOIN function:
but without success - it is assigning all the data, not only related to the manager. Could you please help me with this?
Go to Solution.
Please see this article on how to leverage the PATH function for this.
On the Right PATH() - A DAX/Power Query approach to working with parent/child hierarchies. - P3 Adap...
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
View solution in original post
works great - this is what I wanted to achieve, thank you very much!
Check out the News & Announcements to learn more.
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!