Forum Discussion
Create True/False variable based on other row grouping
i am not good at M, here is a workaround for you
ryan_mayu Thank you, I believe that will probably work. There are only two options in that column (well, there are also blanks, will that be a problem you think?). However I'm having trouble implementing it. In this picture you'll see the actual column names (slightly diffent than what I gave you). And I'm assuming in your code where it said 'table' that should be the name of the table? If so its LIRB Approval and you can see that there.
The problem is it says its expecting a token ')' and I cant see where that would fit:
Any ideas? Am I missing something obvious?
not creating a column in PQ. you need to close the PQ window and use DAX to create a column
Will it still then be available later on in Power query? I need to do later power query steps based on that column being available.
i am not good at M, here is a workaround for you
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?