Data Ranges

[mjustintaylor]

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)

[v-frfei-msft · Accepted 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" )
        )
    )

[AndrejZitnay]

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

[mjustintaylor]

Thanks, Andrej

I will give this a go.

KRs

Justin