Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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]
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |