We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Hi all,
I've a doubt regarding Path Function.
In my data I've Reporting Manager ie(Parent) and Employees that work under Parent.
As you see my data has 2 Parent
Below is the snip of sample data.
is there any way to bypass any 1 parent and work on it??
because if my data has 2 parent Path function(DAX) doesnt work.
Is it because my data has 2 parents that's why I'm getting below error?
Please Help.
Hi,
If I am not mistaken the error isn't because of the 2 parent layer, it is because you have the data "Mulahi Hitesh" as a name in "REporting Manager" that does not exist in "Employee" column.
It means you have a manage that is not an employee in the particular organization.
Please mark as a solution if it helps
Thanks for your Kudos
@Anonymous , Please clean and trim and replace "" with null in the power query.
Seems like some data quality issues. It is giving the error manager's name is not present as an employee
Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4
Power Query Replace Value: https://youtu.be/hkZhZbR7Kmk
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 53 | |
| 38 | |
| 33 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 67 | |
| 62 | |
| 38 | |
| 34 | |
| 22 |