If x = A,b,c,d True, it not, false

[tylerdv]

Hi All

Getting into something that would be pretty easy in Excel but im struggling in Power BI

I have a list of product, some of them are current, some of them are legacy

I want a formula that creates a new column, marking it as current or legacy

EG, IF (X = A or B or C, Current, Legacy)

What would be the easiest way to do this? Can i also point X to look at a seperate Table (there is quite a few current products, but even more legacy ones)

Thanks heaps in advance

Tyler

[Phil_Seamark]

HI @tylerdv

Are A, B & C columns in a table or hardcoded measures?  

Cheers,

Phil

[MarcelBeug]

In the query editor, you can add a column with formula:

= if List.Contains({4,5},[ProdID]) then "Current" else "Legacy"

{4,5}  is the list with current products, which might be replaced by a table/column, e.g. CurrentProducts[ProdID]