Forum Discussion
Add new Conditional Column
I have a table like below, 2 types of products. I want the last column Margin as calculated like: For A: It is Revenue - T Price & For B: It is Revenue - M Price. How do I set up the Margin colum...
Anonymous you can write a measure like this
Measure = SWITCH ( TRUE (), MAX ( 'Table 1'[Product type] ) = "A", SUM ( 'Table 1'[Revenue] ) - SUM ( 'Table 1'[T Price] ), MAX ( 'Table 1'[Product type] ) = "B", SUM ( 'Table 1'[Revenue] ) - SUM ( 'Table 1'[M Price] ) )or a calculated column
Column = SWITCH ( TRUE (), 'Table 1'[Product type] = "A",'Table 1'[Revenue]- 'Table 1'[T Price] , 'Table 1'[Product type] = "B", 'Table 1'[Revenue] - 'Table 1'[M Price] )
Hi,
The below is one of ways to create a calculated column.
Margin CC =
IF(
Data[Product type] = "A" , Data[Revenue] - Data[T Price] ,
IF ( Data[Product type] = "B" , Data[Revenue] - Data[M Price] ,
BLANK()
)
)