Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 !
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
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
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
83 | |
67 | |
62 | |
46 | |
45 |