I receive a data set similar to the table below. I would like to add a column in Power Query to determine if all values are zero on a given row. Item 2 is the only row that meets the criteria as all three values are zero. Item 1 does not meet the criteria even though the SUM of the row equals zero. I would like to add a column that returns TRUE/FALSE based on my criteria. Any help or suggestions appreciated.
Name | 2020 amount | 2021 amount | 2022 amount |
item 1 | -5 | 5 | 0 |
item 2 | 0 | 0 | 0 |
item 3 | 3 | 0 | 3 |