Forum Discussion
Helper IIf Participant is in Resource
Hi All,
I'm needing a bit of help developing some logic that would filter out only the correct particpants for a task based on the resource.
The output I'm looking for is the True Participants column. I need a formula that says if participant is in resource listed for task then they are a true particpant. The problem is that I have hundreds of resources and thousands of particpants so a really long if statement is out of the question.
What other alternatives should I be looking for? Do I need a seperate resource and particpant table to look up to?
Any help is appreciated.
Thank you
1 Reply
- Greg_Deckler
Community Champion
Daxtothemax I am not understanding the logic as to how True Participants gets calculated. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
