If statement in different tables

[nataliesmiy1357]

Good morning!  I would like to make an if statement as a mini filter with my data.

I have two tables that are not connected (my company won't let me connect them) - and I need to make an if statement connecting the two employee id's.

So if employeeid = team member employee id, I want to print the level 1 date, level 2 date, level 3 date, level 4 date, and the trainer name.

Please let me know what else I can do to help provide more information.  I am unable to post the pbix due to my company's restrictions.

[v-jingzhang]

Hi @nataliesmiy1357 

You can use the Table feature to provide some sample data. Or prepare sample data in an Excel workbook, copy a data range and paste it in post directly. See How to provide sample data in the Power BI Forum

Which table does the level 1 date, level 2 date, level 3 date, level 4 date, and the trainer name come from? Does employeeid and team member employee id should be in one to one relationship? 

Best Regards,
Community Support Team _ Jing

[nataliesmiy1357]

There is one table with level 1 date, level 2 date, level 3 date, level 4 date, employeeid and the trainer name (the table is called TeamMember) and then there is one table with employeeid  and other data called TrainingData.

I want to join them on the employeeid, but the tables aren't directly connected with a relationship and I can't change it due to my companys structure.

[smpa01]

@nataliesmiy1357  would be lot quicker and optimum for everyone if you can provide a sample data with desired output. We can very quickly get to the bottom of it.

[nataliesmiy1357]

so, this would be the table TeamMember:

employeeid	level1date	level2date	level3date	level4date	provider
0001	1/2/2021				persona
0002		1/4/2021			personb
0003			5/3/2020		persona
0004				5/4/2020	personb
0005	1/5/2020				persona
0006			4/2/2021		personb

and this would be the TrainingData table

employeeid	employee Name	trainingName	score
0001	TestPerson	TrainingA	3
0002	TestPerson2	TrainginB	4
0003	TestPerson3	TrainingC	2
0004	TestPerson4	TrainingA	5

[amitchandak]

@nataliesmiy1357 , check if path and path length can help

https://radacad.com/parsing-organizational-hierarchy-or-chart-of-accounts-in-power-bi-with-parent-ch...

[nataliesmiy1357]

so, this would be the table TeamMember:

employeeid	level1date	level2date	level3date	level4date	provider
0001	1/2/2021				persona
0002		1/4/2021			personb
0003			5/3/2020		persona
0004				5/4/2020	personb
0005	1/5/2020				persona
0006			4/2/2021		personb

and this would be the TrainingData table

employeeid	employee Name	trainingName	score
0001	TestPerson	TrainingA	3
0002	TestPerson2	TrainginB	4
0003	TestPerson3	TrainingC	2
0004	TestPerson4	TrainingA	5

[smpa01 · Accepted solution]

@nataliesmiy1357  pbix is attached

[nataliesmiy1357]

I'm not sure how to attach a pbix.... this is close, but I don't want the max.  I want just the value.

So when employee id  is 0001, I want to see their level dates (all of them) with the training name.  Does that make sense?

[smpa01]

@nataliesmiy1357  in your sample there is only one instance of level1 date

 I am not understanding

[smpa01]

@nataliesmiy1357  did it resolve the issue?

[nataliesmiy1357]

I'm a bit confused... How would I do that?