Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Question on Conditional Column as Parameter

I am working on a skillset survey, and the rating is know of, beginner, intermediate, advanced and expert, and I have used a conditional column to assign values 1, 2, 3, 4, and 5. I would like to kee...
Need Help
Tutorial Requests
mussaenda's avatar
mussaenda
Community Champion
6 years ago

Anonymous,

 

I have attached the pbix link from what I understood from your explanation.

Hope this helps.

https://gofile.io/?c=4Eaksj

 

BTW, I have changed your sample data just to see differences.

 

NameDepartmentProject IPMA - AProject IPMA - BProject IPMA - CProject IPMA - DProject PMP Project ITSMProject ScrumProject Prince 2 - PrincessProject Prince 2 - Change Management
MichaelDevelopment  Know of  Advanced Beginner  
KevinConsultancyAdvancedIntermediateBeginnerKnow of   Know of  
Michael 2Development  Know of  Advanced Intermediate  
Kevin 2ConsultancyKnow ofBeginnerIntermediateAdvanced  Advanced  
Michael 3Development  Expert Intermediate Beginner  
Kevin 3ConsultancyIntermediateBeginnerAdvancedAdvanced  Expert  

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

That is exactly what I was hoping to do 😄

 

Can I perhaps trouble you to explain me how to set up the query for future use?

Thank you very much!