Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
@nataliesmiy1357 pbix is attached
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
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.
@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.
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 |
@nataliesmiy1357 , check if path and path length can help
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 |
@nataliesmiy1357 pbix is attached
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?
@nataliesmiy1357 in your sample there is only one instance of level1 date
I am not understanding
@nataliesmiy1357 did it resolve the issue?
I'm a bit confused... How would I do that?
User | Count |
---|---|
93 | |
83 | |
77 | |
72 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |