Power BI
Draft a DAX measure for rolling 12-month revenue
Generate a working DAX measure for a rolling revenue view.
Audience: Corporate finance, analystsDifficulty: Intermediate
Input needed
The table and column names in the Power BI data model
Prompt
Draft a DAX measure that calculates rolling 12-month revenue, given this data model: [describe tables and columns]. Explain what each part of the formula does so it can be adapted to similar rolling-window measures.
Expected output
A working DAX measure with a line-by-line explanation.
GP
Recommended model: GPT
The most versatile choice for spreadsheets, coding, and automation.
Part of the Management Reporting workflow.