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 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"
Solved! Go to 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
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
Hi Prakash,
Can't download image, can you please reattach screen shot
Thanks
Just uploaded a new image. Please check again, thanks for your help.
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |