Forum Discussion
Returning a static column value based on another column
New PowerBi user here. I have a dynamic table with data like this: Category Gross Margin Gross Margin per unit Target per unit A 3000 $3.25 ? B 200 $5 ? C 500 $7.20 ? D...
amitchandak
Super User
Super Usergmichalec , Not very clear,
You can create a new column like
Switch( [Category],
"A", 50,
"B", 20,
"C", 30,
"C", 40 )