Suhail G

Logical operator || is easy and convenient to use than OR operator in sense of syntax when we compare more than two criteria. But logical operator IN is most interesting and easiest operator than previous two operators. Simple syntax, No confusion. Not?

New comment 29d ago

Suhail G

0 likes • 30d

@Muhammad Asif Suppose we have a table named Data, to find required result with logical operators II and OR. Result = IF(Data[City] = "Lahore" || Data[Salary] > 50000 || Data[Age] < 50, "Ok", "Not Ok" The result will be in form of Ok if all criteria matches otherwise will return Not ok. Also we can use OR operator to find required result with syntax: Result = IF( OR( OR( Data [City] = "Lahore", Data [Salary] > 50000 ), Data[Age] < 50 ), "Ok", "Not Ok" I was unable to use IN to find the result. so how to use IN here, kindly elaborate it.

Suhail G

1 like • 29d

@Muhammad Asif yes sir. Understood. IN is used to filter a single column values. Thank you.

Muhammad Aftab

Jun 6 •

General discussion

AOA

I am Muhammad aftab. I have watched all the recorded sessions, and they were very comprehensive and informative. we gained a lot of knowledge and learned many useful Power BI techniques. Now we are waiting for the follow-up live session and are excited to attend it together with our batchmates. Personally, I really liked your teaching style. your method of explaining concepts was excellent and easy to understand. throughout the sessions, we several questions, and we will be posting them one by one n the community on a daily basis. Thank you for your time and effort dear Sir.❣️

New comment Jun 8

Suhail G

0 likes • Jun 7

@Rashid Hassan no doubt.

1-10 of 12

Level 2

9points to level up

Suhail G

@suhail-g-3519

Excel & Power BI Learner, Graduate in Computer Science, working as Sales Operations Assistant.

Active 5d ago

Joined May 18, 2026

Bahawalpur, Punjab_Pakistan

Contributions

Followers

Following