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
ryan_mayu
Super User
Super Usernot creating a column in PQ. you need to close the PQ window and use DAX to create a column
JoeCrozierHelper II
Helper IIWill it still then be available later on in Power query? I need to do later power query steps based on that column being available.
- ryan_mayu
i am not good at M, here is a workaround for you
- JoeCrozier
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_mayu
yes, any other issues you encountered?