Skip to main content

Power BI

Needs Votes

PATHX and CONTAINSX Dax formulas

Vote (2) Share
Topher60657's profile image

Topher60657 on 26 Jan 2018 21:20:04

Would it be possible to get a PATHX and CONTAINS functions? We would first be able to filter the context of our data source, like other *X functions and then specify the relevant Parent/Child columns for the PATH function or the to see if the child column contains the parent using the CONTAINSX function. The end goal is to be able to show how a supervisor hierarchy changes through time. The formulas would look like this:

PATHX(filter(table,filter rules),[child],[parent])

CONTAINSX(filter(table,filter rules),[lookup column],[value])