Forum Discussion
calculated columns based on condition
Hi, I have sample data as above. I want to add calculated columns for below based on Associate and Opportunity Number fields in data above.
1. Number of associates who created 0 opportunity
2. Number of associates who created 1-5 opportunity
3. Number of associates who created 10 opportunity
4. Number of associates who created 10+ opportunity
can someone assist , thanks.
4 Replies
mdevm solution is attached, tweak it as your feel like.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Hi,
It should be possible to solve this question with a measure. Share some data to work with.
mdevm , You can create a calculated column by usin nested IF condition or a measure with SWITCH case.
Regards,
Manikumar
Hi mdevm , can you share some sample data (remove sensitive info) and expected result with the conditions?
