The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
94 | |
94 | |
86 | |
69 | |
65 |
User | Count |
---|---|
240 | |
125 | |
122 | |
82 | |
80 |