topic Re: Add new Conditional Column in DAX Commands and Tips

Add new Conditional Column

Anonymous — Thu, 30 Dec 2021 00:51:22 GMT

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 column to get the above conditions?

Product type	Revenue	T Price	M Price	Margin
A	40	36		40-36
A	54	50		54-50
B	32	28	27	32-27
B	43	40	38	43-38
A	33	30		33-30
B	29	27	25	29-25

Re: Add new Conditional Column

smpa01 — Thu, 30 Dec 2021 01:05:34 GMT

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] )

Re: Add new Conditional Column

Jihwan_Kim — Thu, 30 Dec 2021 04:04:37 GMT

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()

)

Re: Add new Conditional Column

Anonymous — Tue, 04 Jan 2022 05:56:36 GMT

Hi Anonymous,

Did these suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng