DAX: Time Intelligence — MoM Margin Trend

Meridian Retail Co. · Power BI · intermediate

The brief

Nura wants to see when the margin decline started — was it before the discount campaign or exactly when it kicked off? Build a combo chart covering January to December 2023 with monthly revenue bars and a gross margin % line. Also build two time intelligence measures: Gross Margin % LM (last month) and MoM Margin Change in percentage points.

Independent grading

97/100

Achieved 1 Nov 2026

Graded automatically against a fixed rubric for this task. Feedback and submitted work remain private to the analyst.

What is DataSimHQ?

A practice platform where analysts complete graded business tasks for simulated companies in SQL, Power BI, and Excel, and build a portfolio of proven work. Learn more