adding a calculated column based on contents of two different columns

[JimB-GA]

Good afternoon all.  

I have a table with columns named "status" and "Age".  I would like to have the calculated column return a value of "Late" if the status column = "Open" and the "Age" column is > 30.  I know how to do this in both Excel and Access, but Power BI solution eludes me.

All help is greatly appreciated.

Jim L

[d_gosbell · Accepted solution]

So that would be something like the following:

= IF( table[Status] = "Open" && table[Age] > 30, "Late")

[v-chuncz-msft · Accepted solution]

@JimB-GA 

By the way, you may also add a custom column in Query Editor.

if [status] = "Open" and [Age] > 30 then "Late" else null

[d_gosbell · Accepted solution]

So that would be something like the following:

= IF( table[Status] = "Open" && table[Age] > 30, "Late")