Benchmark Tasks

30 DAX coding tasks across aggregation, time intelligence, filtering, calculation, table manipulation, iterator, context transition.

Filter:

basic (6)

Total Sales Amounttask-001

Aggregationmeasuresum

Count of Customerstask-002

Aggregationmeasurecount

Average Unit Pricetask-003

Aggregationmeasureaverage

Distinct Product Counttask-004

Aggregationmeasuredistinctcount

Total Order Quantitytask-005

Aggregationmeasuresum

Handle Missing Data with BLANKtask-025

Calculationmeasureblank

intermediate (13)

Year-to-Date Salestask-006

Time Intelligencemeasuretime-intelligence

Previous Year Salestask-007

Time Intelligencemeasuretime-intelligence

Sales by Category Filtertask-008

Filteringmeasurecalculate

Sales Summary by Categorytask-011

Table Manipulationtablesummarize

Product List with Renamed Columnstask-012

Table Manipulationtableselectcolumns

Product Percentage of Category Totaltask-015

Context Transitioncalculated-columncontext-transition

Granularity-Aware Measure with HASONEVALUEtask-017

Context Transitionmeasurehasonevalue

Multiple Filter Conditionstask-019

Filteringmeasurecalculate

Product Ranking with RANKXtask-022

Iteratormeasurerankx

Top 5 Products with TOPNtask-023

Table Manipulationmeasuretopn

Safe Ratio with Cascading Fallbackstask-026

Calculationmeasuredivide

Safe Year-over-Year with Missing Datatask-027

Time Intelligencemeasuretime-intelligence

Same Month Previous Year Comparisontask-029

Time Intelligencemeasureparallelperiod

advanced (11)

Year-over-Year Growth Percentagetask-009

Calculationmeasuretime-intelligence

Running Total with CALCULATE and FILTERtask-010

Iteratormeasurerunning-total

Union of High-Value Transactionstask-013

Table Manipulationtableunion

Year-Category Analysis Matrixtask-014

Table Manipulationtablecrossjoin

Virtual Relationship with TREATAStask-016

Context Transitionmeasuretreatas

Running Count with EARLIERtask-018

Context Transitioncalculated-columnearlier

Percentage of Total with ALLEXCEPTtask-020

Filteringmeasureallexcept

Filter Intersection with KEEPFILTERStask-021

Filteringmeasurekeepfilters

90th Percentile Order Valuetask-024

Iteratormeasurepercentilex

3-Month Rolling Averagetask-028

Time Intelligencemeasuredatesinperiod

Fiscal Year-to-Date (July Start)task-030

Time Intelligencemeasuredatesytd

Loading tasks...

Benchmark Tasks

30 DAX coding tasks across aggregation, time intelligence, filtering, calculation, table manipulation, iterator, context transition.

Filter:

basic (6)

Total Sales Amounttask-001

Aggregationmeasuresum

Count of Customerstask-002

Aggregationmeasurecount

Average Unit Pricetask-003

Aggregationmeasureaverage

Distinct Product Counttask-004

Aggregationmeasuredistinctcount

Total Order Quantitytask-005

Aggregationmeasuresum

Handle Missing Data with BLANKtask-025

Calculationmeasureblank

intermediate (13)

Year-to-Date Salestask-006

Time Intelligencemeasuretime-intelligence

Previous Year Salestask-007

Time Intelligencemeasuretime-intelligence

Sales by Category Filtertask-008

Filteringmeasurecalculate

Sales Summary by Categorytask-011

Table Manipulationtablesummarize

Product List with Renamed Columnstask-012

Table Manipulationtableselectcolumns

Product Percentage of Category Totaltask-015

Context Transitioncalculated-columncontext-transition

Granularity-Aware Measure with HASONEVALUEtask-017

Context Transitionmeasurehasonevalue

Multiple Filter Conditionstask-019

Filteringmeasurecalculate

Product Ranking with RANKXtask-022

Iteratormeasurerankx

Top 5 Products with TOPNtask-023

Table Manipulationmeasuretopn

Safe Ratio with Cascading Fallbackstask-026

Calculationmeasuredivide

Safe Year-over-Year with Missing Datatask-027

Time Intelligencemeasuretime-intelligence

Same Month Previous Year Comparisontask-029

Time Intelligencemeasureparallelperiod

advanced (11)

Year-over-Year Growth Percentagetask-009

Calculationmeasuretime-intelligence

Running Total with CALCULATE and FILTERtask-010

Iteratormeasurerunning-total

Union of High-Value Transactionstask-013

Table Manipulationtableunion

Year-Category Analysis Matrixtask-014

Table Manipulationtablecrossjoin

Virtual Relationship with TREATAStask-016

Context Transitionmeasuretreatas

Running Count with EARLIERtask-018

Context Transitioncalculated-columnearlier

Percentage of Total with ALLEXCEPTtask-020

Filteringmeasureallexcept

Filter Intersection with KEEPFILTERStask-021

Filteringmeasurekeepfilters

90th Percentile Order Valuetask-024

Iteratormeasurepercentilex

3-Month Rolling Averagetask-028

Time Intelligencemeasuredatesinperiod

Fiscal Year-to-Date (July Start)task-030

Time Intelligencemeasuredatesytd