Solved: HOW TO WRITE IF CONDITION IN POWER BI

Anonymous · ‎12-17-2020

I want to make a new column by using fields that are already in the table.

Condition is if: QUALIFIED AND MQL = 1, WHAT IS THE SOFTWARE_AMOUNT.

BELOW IS THE TABLE:

CAPTURE

GilbertQ · ‎12-17-2020

Hi @Anonymous

If you want to create a new column you could right click and select new Column with the following syntax

If Column = IF('Table'[Qualified]= 1 && 'Table'[MQL] = 1, [Software_Amount])

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

GilbertQ · ‎12-17-2020

Hi @Anonymous

If you want to create a new column you could right click and select new Column with the following syntax

If Column = IF('Table'[Qualified]= 1 && 'Table'[MQL] = 1, [Software_Amount])

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

HOW TO WRITE IF CONDITION IN POWER BI