Forum Discussion
Use Result from Intersect as a Filter Condition
Is it possible to use the result from the Intersect function as a clause within a Filter Condition? If so, how would I go about doing this? I haven't been able to find anything with regardsds to us...
I do not think I got the problem completely.
Try following.
Using Edit Query (Under Transform data in the new Office ribbon), unpivot the, separated data. Use the Split Column.
Means you should get the rows for 3 and 4 when it is 3,4
Not you can join these columns directly, by create a new table with all these id and join to both of them
Create measures to count of close and open and based on that take final call.
If possible please share a sample pbix file after removing sensitive information.Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970