Data Analyst Interview Series — Part 14

Аналитика рынка

Бесплатно. Вход по почте.

Откликнуться

Загрузите резюме — мы свяжем вас с работодателем напрямую через нашу базу.

Описание

📊 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

Полное описание, компания и ссылка на вакансию — после входа. Войти

Контакты работодателя (email/phone/telegram) скрыты из публичного превью — отправьте резюме, чтобы мы связали вас напрямую.