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.
Hello, I'm hoping for some help on making a measure using an IF statement.
I have a data set of quotes which will be made against 4 different products. Each product has a different retention percentage. I want to calculate the retention rates based on the product e.g:
If Product Type = "Product A", Cash Price * 0.25
If Product Type = "Product B", Cash Price * 0.5
If Product Type = "Product C", Cash Price * 0.75
If Product Type = "Product D", Cash Price * 0.8
When I try to create an If statement as a measure, it won't let me use any of the columns of my table.
Can anyone help?
Solved! Go to Solution.
@KatieH , Try a new column
Switch(True(),
MAX( [Product Type] ) = "Product C", SUM( [Cash Price] ) * 0.75,
MAX( [Product Type] ) = "Product D", SUM( [Cash Price] ) * 0.8
)
@KatieH , Try a new column
Switch(True(),
MAX( [Product Type] ) = "Product C", SUM( [Cash Price] ) * 0.75,
MAX( [Product Type] ) = "Product D", SUM( [Cash Price] ) * 0.8
)
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 |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |