Forum Discussion

BenHoward's avatar
BenHoward
Helper I
5 years ago
Solved

Using DAX to remove invalid PATH rows

Hi,  I'm using the PATH function in DAX to work out the hierarchy in an organsation, but as usual I have data quality issues which cannot be resolved in the source data.  My HR table has invalid par...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    BenHoward 

    Create a new table:

    New Table = 
	FILTER(
		Table1,
		Table1[Supervisor ID] IN ALL(Table1[EmpID])
	)

     

BenHoward's avatar
BenHoward
Helper I
5 years ago

Fantastic, thank you.  One last question if I may, assuming my 1st table had 10 other columns, but I only wanted to return the 3 columns Emp Name, EmpId and Supervisor Id, how would I do that?  Thanks again!!

 

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    BenHoward 

     

    You can use SELECTCOLUMNS function