Custom Column, If Statement Power BI

Today I face simple requirement, I need count on Gender, Entered data most of employee did not filed Gender in ERP system. So it is decided we show These records as male.For this I have to edit query and add custom column and update its value with If Condition.

For this I have to edit Query in power BIAdd Custom column with Employee Gender and similar logic.

= if [Gender]= "None" then "Male"
else [Gender]

alirazazaidi

Ali Raza Zaidi, Microsoft ERP Consultant, Currently working for Business Experts Gulf in United Arab Emirates. Specialized in HR & Payroll, Supply Chain and Financials modules.