Forum Discussion
Solved
Create a new table based on many conditions
I'm creating a dashboard to show the training conclusion percentage filtering by all company's areas, sub areas and levels. In order to get all the info, I have to check all trainings an employee is...
can we do this in pq? i think that will be easier.
However the output is different from yours.
i got Matthew for Communication Training
and Maria has not completed for Communication training since we only see PowerBI training in training database
pls see the attachment below
ryan_mayu
Super User
Super Usercan we do this in pq? i think that will be easier.
However the output is different from yours.
i got Matthew for Communication Training
and Maria has not completed for Communication training since we only see PowerBI training in training database
pls see the attachment below
Oh! It's exactly this!
How did you do it? You merged the tables and created a custom collumn? How did you make the merged table?
Thanks in advance!
- ryan_mayu
I did that in PQ. you can check the transform steps in PQ.