EXCEPT Function
The EXCEPT function in DAX is one of the most commonly asked topics in Power BI interview questions. In this article, we explain the definition of EXCEPT, real-time scenario-based examples, and how this function is applied in Power BI reports.
Whether you are preparing for a Power BI Interview, learning DAX functions, or practicing scenario-based questions for Data Analyst jobs, understanding EXCEPT is very important. This tutorial will help you master EXCEPT and use it effectively in your Power BI dashboards.
👉 Read till the end to learn:
-
What is EXCEPT in DAX?
-
Real-time interview scenarios using EXCEPT
-
Difference between EXCEPT and other table functions
-
How EXCEPT is used in Power BI for comparisons
For more tutorials, visit Telugu Data Hub – Your Learning Partner for Power BI, SQL, Python, and Data Analyst Job Preparation.
EXCEPT Function Definition :
The EXCEPT function in DAX returns a table that contains rows present in one table but not in another.
Syntax: EXCEPT(<Table1>, <Table2>)
✔️ If a row exists in Table1 but not in Table2, EXCEPT returns that row.
✔️ It is mostly used to compare two tables and find the differences.
✔️ Common interview use case: finding records in one dataset that are missing in another.
Check this for Video Tutorial Telugu : Click Here
For Data Set : Check Below
Sheet 1 :
| Kumar | 52 | 984654542 | M | Srikakulam |
| Giri | 35 | 9646543241 | M | Vizag |
| Preethi | 56 | 95432413 | F | Vizianagaram |
| Anusha | 13 | 978432134 | F | Guntur |
| Sravani | 25 | 989745454 | F | Nellore |
| Vamsi | 30 | 94854153414 | M | Kadapa |
Sheet 2 :
| Giri | 35 | 9646543241 | M | Vizag |
| Preethi | 56 | 95432413 | F | Vizianagaram |
| Anusha | 13 | 978432134 | F | Guntur |
| Sravani | 25 | 989745454 | F | Nellore |
Thank You!!!!!!!!! All the Best!!!!!