Forum Discussion
JoeCrozier
Helper II
Helper IICreate 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...
i am not good at M, here is a workaround for you
JoeCrozierHelper II
Helper IIThis 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_mayu
Super User
Super Useryes, any other issues you encountered?
- JoeCrozier
Nope, worked great!
- ryan_mayu
ok, glad to hear that