Measure in If Statement and Return

[gauravnarchal]

Hello – How can I create a measure to show

If Product code = 10 return 30 or

If Product code = 12 return 50 or

If Product code = 13 return 70

Tabel Name = Sale

Name	Branch	Product Code	(Measure) Add column and show the value in each row
ABC Intl	NYC	10	30
ZZZ Logistics	LON	10	30
ABC Intl	CAI	12	50
ZZZ Logistics	MEL	12	50
ABC Intl	DEL	12	50
ABC Intl	SHA	13	70
ABC Intl	NYC	13	70
ZZZ Logistics	NYC	13	70

[pra137 · Accepted solution]

hi @gauravnarchal 
you can use this measure you will get result

Measure =

var a=SUM(sale[Product Code])

var b=IF(a=10,30,IF(a=12,50,IF(a=13,70)))

Return

b

[Jihwan_Kim · Accepted solution]

Hi, @gauravnarchal 

Please check the below. The formula is for creating a new column.

New Column =
SWITCH ( Sale[Product Code], 10, 30, 12, 50, 13, 70 )

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[pra137 · Accepted solution]

hi @gauravnarchal 
you can use this measure you will get result

Measure =

var a=SUM(sale[Product Code])

var b=IF(a=10,30,IF(a=12,50,IF(a=13,70)))

Return

b