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)
Go to Solution.
Hi @mjustintaylor ,
We should get the A2 by VAR like this.
VAR A2 =
CALCULATE ( SUM ( 'Table'[value] ), FILTER ( 'Table', 'Table'[index] = 2 ) )
AND ( A2 >= 0, A2 <= 100 ),
AND ( A2 >= 101, A2 <= 500 ),
IF ( AND ( A2 >= 501, A2 <= 1000 ), "Answer 3", "Void" )
Have you tried :
= IF(A2>=0 && A2 <=100,"Answer A","Answer B") or another combinations.
IF first option && IF second option, than ...
I will give this a go.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!