Forum Discussion
JoeCrozier
2 years agoHelper II
Create True/False variable based on other row grouping
This might be pretty similar to this one: https://community.fabric.microsoft.com/t5/Desktop/Determine-if-a-value-exists-in-one-column-when-grouping-by/td-p/2187917 but I have data like this in Po...
- 2 years ago
i am not good at M, here is a workaround for you
ryan_mayu
2 years agoSuper User
i am not good at M, here is a workaround for you
JoeCrozier
2 years agoHelper II
This seems to work great! To make sure i understand it and can implement, seems like you: copied the query, in the new copy you grouped by protocol and counted, and then you merged that count back into the original query, and created a true/false column for if the count was 2?
- ryan_mayu2 years agoSuper User
yes, any other issues you encountered?
- JoeCrozier2 years agoHelper II
Nope, worked great!
- ryan_mayu2 years agoSuper User
ok, glad to hear that