Data Analyst Interview Series — Part 14

Market insights

Free. Sign in with email.

Apply

Upload your CV — we will connect you with the employer directly through our pool.

Description

📊 Data Analyst Interview Series — Part 14 In the previous part, we covered Power BI fundamentals. Now let's focus on one of the most important areas in Power BI interviews: 📊 DAX & Context in Power BI 1️⃣ What is DAX and why is it important? Sample Answer: DAX stands for Data Analysis Expressions. It is the formula language used in Power BI to create measures, calculated columns, and calculated tables. DAX is important because it allows us to create business calculations that go beyond simple aggregations. For example: Total Sales = SUM(Sales[SalesAmount]) I can then use this measure in different visuals and Power BI will automatically recalculate it based on filters and selections. 2️⃣ What is filter context in DAX? Sample Answer: Filter context refers to the filters that affect how a DAX calculation is evaluated. For example, if I have a Total Sales measure and select: Region = South Year = 2026 Power BI calculates Total Sales only for records matching those filters. This is why the same measure can return different results depending on the filters applied to a report. 3️⃣ What is row context? Sample Answer: Row context means that DAX evaluates an expression for the current row. It is commonly encountered when working with calculated columns. For example: Profit = Sales[Revenue] - Sales[Cost] Power BI evaluates this calculation separately for each row in the Sales table. A simple way to remember: Row context → Current row Filter context → Current

Full description, company and the link to apply — after you sign in. Sign in

Employer contacts (email/phone/telegram) are hidden from the public preview — send your CV, and we will connect you directly.