How do I put a formula in PowerBI?

[loade]

Hello

I loaded an excel file on powerbi and I want to create a column where I want to run a formula (if column1 = Something1 and Column2 > Column3, then display Column4).

I have not clue how to do this. I click to create a New Custom Column and it it says to enter the column formula, but I start typing IF and nothing comes up!

How can there is no IF in the available formula syntax???

Thanks!

[Olly]

There are two parts to Power BI - the Query Editor (Power Query, which uses M language to import and transform data), and the Data Model (where you can add Calculated Columns and Measures to your data model, using DAX language).

Are you trying to add your column in the Query Editor (M) or to the table in the data model (DAX) ?

There are IF functions available in both languages, but the syntax is quite different!