Power Query determine if all values on row are zero

Joe_S

New Member
Joined
Feb 22, 2012
Messages
6
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.


Name2020 amount2021 amount2022 amount
item 1-550
item 2000
item 3303
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
maybe custom column:
if [2020 amount] = 0 and [2021 amount] = 0 and [2022 amount] = 0 then true else false
 
Upvote 0

Forum statistics

Threads
1,223,803
Messages
6,174,687
Members
452,577
Latest member
Filipzgela

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top