Forum Discussion
DanaMcKinniss
6 years agoRegular Visitor
Classify account when multiple classifications may be possible
I have a list of accounts for various services that are being implemented. Each service may have an implementation at a different stage, however, I want to classify the account based on the most favorable stage. I took the stages "launched", "on target", and "delayed" and translated them to 1, 2 and 3. Essentially if an account had a 1 and a 2, I'd want the account to be represented by 1. What function can I create to acheive this?
1 Reply
- parry2k
Super User
DanaMcKinniss I would recommend to share sample data and expected output. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490