Forum Discussion
Helper IIComplex Engagement Dashboard
Hi ManchevB ,
I think you first need to make sure that PowerBI has access to both databases (the one with submitted skills and the one with qualified engineers). The databases should have a common key (e.g. Employee ID) that is used to join them. Import both datasets into PowerBI and use the common key to create a relationship between the two datasets.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi ManchevB ,
I create two tables as you mentioned.
Then I create a measure and here is the DAX code.
Measure = IF(MAX('T1'[FinishTime])=1,"Yes","No")Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ManchevBHey, thank you for looking into this.
The problem I have is that the way to tell if engineer has submitted skills information is to simply add the "Skills" column, however the other data source with all engineers available doesnt have "Skills" column because it is a completely different source .. .
Hi ManchevB ,
I think you first need to make sure that PowerBI has access to both databases (the one with submitted skills and the one with qualified engineers). The databases should have a common key (e.g. Employee ID) that is used to join them. Import both datasets into PowerBI and use the common key to create a relationship between the two datasets.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.