Forum Discussion

ABAXA's avatar
ABAXA
New Member
3 years ago
Solved

Create new bool column depending on previous rows

I'm trying to create a new column named "Exists at least One time" The output should be like shown in the table below.   I believe that the logic will be : 1- for each path, check how many ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi ABAXA ，

     

    Here I suggest you to try this code to create a custom column in Power Query.

    if 
Table.RowCount(
let _path = [Path] in
Table.SelectRows(#"Changed Type",each [Path] = _path and [Exist] = true)) = 0 
then
"false"
else
"true"

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi ABAXA ，

 

Here I suggest you to try this code to create a custom column in Power Query.

if 
Table.RowCount(
let _path = [Path] in
Table.SelectRows(#"Changed Type",each [Path] = _path and [Exist] = true)) = 0 
then
"false"
else
"true"

Result is as below.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.