Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@AUDISU
Please use
=
SWITCH (
SELECTEDVALUE ( 'ProductList'[Product] ),
"A", 1500,
"B", 2000,
"C", 3000,
0
)
It should not give an error if you are creating a calculated column. Unless you creating a measure?
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.
@AUDISU
Please use
=
SWITCH (
SELECTEDVALUE ( 'ProductList'[Product] ),
"A", 1500,
"B", 2000,
"C", 3000,
0
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |