📋 Data Model
1 – 20
total sales
profit margin %
YoY growth %
YTD
running total
rank
% of total
distinct count
moving avg
SUM / Total
Average / Mean
Count / Distinct Count
Min / Max
Profit / Margin %
YoY / QoQ / MoM Growth %
YTD / QTD / MTD
Previous Year / Quarter / Month
% of Total / Share
Rank / Top N
Running Total / Cumulative
Moving / Rolling Average
Weighted Average
Conversion Rate
Date Table Generation
Bucket / Tier (Calc Column)
Churn Rate
Retention Rate
New Customers
Closing / Opening Balance
Top N (excluding…)
Threshold Count (> N)
Lifetime Value (CLV)
Cumulative Distinct
Basket Size / AOV
Budget vs Actual Variance
Rolling N-Day/Week Growth
🧩 Solution
No solution yet
Define your data model and describe what you want to calculate, then hit Generate. Everything runs locally in your browser — no internet required.
✨ Structuring your DAX
Something went wrong