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 Community.
In Excel, I can create a formula to give a result on ranges between certain values e.g.
=IF(AND(A2>=0, A2<= 100), "Answer A",IF(AND(A2>=101, A2<=500),"Answer B", IF(AND(A2>=501, A2<=1000),"Answer 3", "Void")))
Is there a Dax equivalent, so I can get this to work directly in Power BI when importing and combining several spreadsheets (the If, And doesn't work)
Solved! Go to Solution.
Hi @mjustintaylor ,
We should get the A2 by VAR like this.
Measure = VAR A2 = CALCULATE ( SUM ( 'Table'[value] ), FILTER ( 'Table', 'Table'[index] = 2 ) ) RETURN IF ( AND ( A2 >= 0, A2 <= 100 ), "Answer A", IF ( AND ( A2 >= 101, A2 <= 500 ), "Answer B", IF ( AND ( A2 >= 501, A2 <= 1000 ), "Answer 3", "Void" ) ) )
Hi @mjustintaylor ,
We should get the A2 by VAR like this.
Measure = VAR A2 = CALCULATE ( SUM ( 'Table'[value] ), FILTER ( 'Table', 'Table'[index] = 2 ) ) RETURN IF ( AND ( A2 >= 0, A2 <= 100 ), "Answer A", IF ( AND ( A2 >= 101, A2 <= 500 ), "Answer B", IF ( AND ( A2 >= 501, A2 <= 1000 ), "Answer 3", "Void" ) ) )
Hello @mjustintaylor
Have you tried :
= IF(A2>=0 && A2 <=100,"Answer A","Answer B") or another combinations.
IF first option && IF second option, than ...
Andrej
Thanks, Andrej
I will give this a go.
KRs
Justin
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |