Forum Discussion
Creating Multiple Results in a column based on a combination of parameters from two other columns
Hello, I am working on a Power BI report that looks at non-numeric data from a SharePoint Library. The report connects directly to the library and pulls related fiels "document name, document sta...
Hi Anonymous
If you want to add a custom column with Power Query, try
if [Section]="Administrative Services" and Text.Contains([Job Classification],"Administrative Assistant") then "Admin Services Administrative Assistant Series" else if [Section]="Administrative Services" and Text.Contains([Job Classification],"Analyst") then "Admin Services Administrative Analyst Series" else if [Section]="Regulatory Compliance" and Text.Contains([Job Classification],"Compliance Agent") then "Regulatory Compliance Agent Series" else nullYou can use multiple else if ... then ... statement pairs to add more conditions.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
v-jingzhang
Community Support
Community SupportHi Anonymous
If you want to add a custom column with Power Query, try
if [Section]="Administrative Services" and Text.Contains([Job Classification],"Administrative Assistant")
then "Admin Services Administrative Assistant Series"
else if [Section]="Administrative Services" and Text.Contains([Job Classification],"Analyst")
then "Admin Services Administrative Analyst Series"
else if [Section]="Regulatory Compliance" and Text.Contains([Job Classification],"Compliance Agent")
then "Regulatory Compliance Agent Series"
else null
You can use multiple else if ... then ... statement pairs to add more conditions.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.