If conditional column based on two columns

[Anonymous]

Hi All,

I have a column where the Total Visitors have been counted , Total Men and Total Women.

I would like to make a new conditional column that result the value "Mix" if the column Total Men has value 1 or higher and the column Total Women has value 1 or higher. See example below in the red markered are:

Any suggestions?

Many thanks !

[v-yuta-msft]

Hi regasanyoto,

Click Query Editor-> Add Columns-> Conditional Column. Then you can add you if... then..,else condition to create your conditional column.

Regards,

Jimmy Tao

[Anonymous]

HI @Anonymous

How about this column?

Mix? = IF(Table1[Men]>0 && Table1[Women]>0, "Mix","One Gender")

 Plase explain if you are looking for something else 🙂

Thanks

Raj

[Anonymous]

Hello @Anonymous,

The formula that you gave me is not working because its return the value Mix.

See the image below:

In the first two rows there are in total 3 visitors and those all women. The new created column callend New Column return Mix.

It suppose return Women.

In the second last row you see three total visitors that contains only Man. It suppose return Man.

Any suggestions?

Thanks