Urgent help in Comparing cell value using AND Operator

[prakash11440278]

HI All,

I need a help in comparing two cell values using AND Opertor in powerbi similar to the below image.

Formula i used in excel is: =AND(B2=B3,A2="MOD",A3="DOV"

[v-jiascu-msft · Accepted solution]

Hi @prakash11440278,

Rows in Power BI are different from them in Excel. So we need to add an index in the Query Editor first. You can check it out in this file.

Column =
VAR currentIndex = [Index]
VAR nextUPN =
    CALCULATE (
        VALUES ( Table1[User Principal Name] ),
        FILTER ( ALL ( 'Table1' ), Table1[Index] = currentIndex + 1 )
    )
VAR nextAN =
    CALCULATE (
        VALUES ( Table1[Application Name] ),
        FILTER ( ALL ( Table1 ), Table1[Index] = currentIndex + 1 )
    )
RETURN
    IF (
        [User Principal Name] = nextUPN
            && [Application Name] = "MOD"
            && nextAN = "DOV",
        TRUE (),
        FALSE ()
    )

Best Regards,

Dale

[Anonymous]

Hi Prakash,

Can't download image, can you please reattach screen shot

Thanks

[prakash11440278]

Just uploaded a new image. Please check again, thanks for your help.