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

Advisory software engineer, Software engineer, Last 4 years focus on Dynamics Ax 2012. MVP and Microsoft Certified trainer for Dynamics AX.