In Excel Power Query, what is the name of the formula language used to write custom transformations?
Excel Data Analysis
Question · Easy
Wedding seating, as a LEFT JOIN
Short
Which Excel feature allows you to load multiple related tables into a single in-memory data model and create relationships between them?
Question · Medium
What is the key behavioral difference between a DAX measure and a DAX calculated column?
Finance Exam Prep Podcast
Listen on Spotify
Podcast
Which DAX function modifies or replaces the filter context applied to an aggregation?
Which DAX function is an iterator that evaluates an expression for each row of a table and returns the sum?
Star schema: a city pop love song to a fact table
In a Power Pivot model with multiple inactive relationships between two tables, which DAX function activates a specific relationship for a single calculation?
Question · Hard
Which Excel dynamic array function returns a subset of an array based on a Boolean condition?
Which Excel lookup function searches in any direction, returns multiple columns, and supports approximate or wildcard match in a single call?
In Power Query, what is the difference between 'Merge Queries' and 'Append Queries'?
A measure shows correct subtotals per row but the grand total does not equal the sum of the rows. What is the most likely cause?
In Power Pivot, how do you trigger a data model refresh from cached data sources?
Which DAX function returns a related value from another table by following an existing many-to-one relationship in row context?
Which Excel feature lets users interactively filter a PivotTable visually using buttons?
Which DAX time-intelligence function returns the value of an expression for the same period one year ago?
What is the primary purpose of conditional formatting in Excel data analysis?
Which SQL clause filters rows BEFORE aggregation is applied?
Sql Fundamentals
Which JOIN returns all rows from the left table and matched rows from the right table, with NULLs where there is no match?
What is the difference between UNION and UNION ALL?
Which window function assigns a unique sequential integer to each row within a partition, with no ties?
Which SQL window function returns the value from a previous row within a partition?
What is a CTE (Common Table Expression) in SQL?
Which SQL clause is required to use aggregate functions like SUM and COUNT alongside non-aggregated columns in the SELECT list?
What is the purpose of the OVER() clause in a SQL window function?
Which SQL function extracts the year from a date column in standard ANSI SQL?
Which SQL string function returns the number of characters in a value?
What does a correlated subquery refer to?
What does a FULL OUTER JOIN return?
Given monthly sales rows, which window expression computes a running total of revenue per customer ordered by date?
Which SQL pattern selects only DISTINCT customers who have made at least one purchase?
What is the result of COUNT(*) versus COUNT(column_name) in SQL?
In Power BI, what is a star schema?
Power Bi
What does Row-Level Security (RLS) do in Power BI?
Which storage mode in Power BI loads data into the in-memory VertiPaq engine for the fastest query performance?
Which Power BI feature allows the same physical dimension table to play multiple roles in a model (e.g., one Date dimension as Order Date and Ship Date)?
What is a bidirectional cross-filter relationship in Power BI?
In dynamic Row-Level Security, which DAX function returns the current user's identity for filtering?
What is the correct syntax for declaring a variable inside a DAX measure?
Which DAX time-intelligence function returns a year-to-date total?
What does a composite model in Power BI allow?
Which Power BI visual is most appropriate for showing the contribution of parts to a whole when there are at most 3-5 categories?
What is the main purpose of a Date table marked as 'Mark as date table' in Power BI?
Which Power BI feature lets you create a single measure that calculates totals across many-to-many relationships using a bridge table?
What is the recommended way to organize measures in a Power BI model with many measures?
What does the SAMEPERIODLASTYEAR DAX function return?
Which Power BI deployment artifact bundles the model, queries, and visuals into a publishable file?
Loading more…