DataPipe
Data
Analyze
Planning
AI
Build
Admin
Upload CSV
⌘K
DataPipe
Analyze
DAX
Loading...
DAX Formula Editor
Evaluate DAX-like formulas with time intelligence on your datasets.
Dataset:
DAX Formula
⌘+Enter to evaluate
SUM(Revenue)
SUM, AVERAGE, COUNT, COUNTROWS, MIN, MAX, DISTINCTCOUNT, TOTALYTD, TOTALQTD, TOTALMTD, SAMEPERIODLASTYEAR, DATEADD, CALCULATE, IF, SWITCH, DIVIDE, ABS, ROUND
✨ AI Write
Evaluate
Example Formulas
Sum Revenue
SUM(Revenue)
Average Profit
AVERAGE(Profit)
Count Rows
COUNTROWS()
Distinct Products
DISTINCTCOUNT(Product_ID)
Year-to-Date Revenue
TOTALYTD(SUM(Revenue), Date)
Quarter-to-Date Revenue
TOTALQTD(SUM(Revenue), Date)
Same Period Last Year
SAMEPERIODLASTYEAR(SUM(Revenue), Date)
Online Channel Revenue
CALCULATE(SUM(Revenue), Channel = "Online")
Profit Margin
DIVIDE(SUM(Profit), SUM(Revenue), 0)
Safe Division
DIVIDE(SUM(Profit), SUM(Revenue), 0)
Max Revenue
MAX(Revenue)
Min Quantity
MIN(Quantity)