Power Query Editor

[Anonymous]

Hi,

I have a column in a table with 10 lakh rows. the given scenario is using conditional column i need to bring whetehr the given numbers is odd or even. Kindly help me how to do this.

I am a beginner in Power BI. Hence posting such a question.

[amitchandak]

@Anonymous ,

In power query you can have a new column

= if Number.IsOdd([column]) then "Odd" else "Even"

in DAX, a new column

if(isodd([Column1]), "Odd", "Even")