topic Re: Use Text Column to IF Statement in DAX Commands and Tips

Use Text Column to IF Statement

AUDISU — Tue, 12 Jul 2022 05:55:00 GMT

Hi, Im new to Power bi and tring to write a DAX function with IF condition.

Ex.

Product	Amount
A	1500
B	2000
C	3000

My formula to calculate value IF('ProductList'[Product] = "A",1500 , IF( 'ProductList'[Product] = "B",2000 , IF( 'ProductList'[Product] = "C",3000, 0)))

It showing me an error in 'ProductList'[Product]. Because It does not allow me to reffer text column.

Can anybody to help me to solve this issue.

Thank you.

Re: Use Text Column to IF Statement

tamerj1 — Tue, 12 Jul 2022 06:53:20 GMT

AUDISU

It should not give an error if you are creating a calculated column. Unless you creating a measure?

Re: Use Text Column to IF Statement

AUDISU — Tue, 12 Jul 2022 06:58:39 GMT

Actually I want to create a mesure. Because I have Month filter in my report. When I change Month the Value should be change.

Thank you.

Re: Use Text Column to IF Statement

tamerj1 — Tue, 12 Jul 2022 07:03:34 GMT

AUDISU
Please use

= SWITCH ( SELECTEDVALUE ( 'ProductList'[Product] ), "A", 1500, "B", 2000, "C", 3000, 0 )

Re: Use Text Column to IF Statement

AUDISU — Wed, 13 Jul 2022 01:34:43 GMT

tamerj1

It;s working.

Thank you.