Here is the dashboard created using DAX functions with this Dataset.
📦 Dataset Overview:
This dataset contains monthly sales records for:
- 12 months of 2024 (Jan–Dec)
- First 7 months of 2025 (Jan–July 1)
You can get the dataset here: https://github.com/slidescope/-Time-Intelligence-Practice-2024-2025-
📌 Fields:
| Column | Description |
|---|---|
| OrderID | Unique order identifier (e.g., ORD2401) |
| Date | Order date (used for time intelligence) |
| Category | Product category (Electronics, Furniture, Clothing) |
| Manager | Sales manager responsible (Amit, Sneha, Ravi) |
| Region | Sales region (North, South, East, West) |
| Sales | Revenue from the order |
| Customer | Customer name or label |
| Profit | Profit made from the order |
📊 Purpose of Dataset:
- Ideal for time-based analysis (YTD, PY, MOM, YOY)
- Can be used to demonstrate DAX functions like
TOTALYTD(),SAMEPERIODLASTYEAR(),PARALLELPERIOD(),PREVIOUSMONTH(),FIRSTDATE() - Useful for Power BI visuals like line charts, matrix tables, and KPI cards
YTD Sales =
TOTALYTD(
SUM(Sales[Sales]),
Sales[Date]
)
MTD Sales =
TOTALMTD(
SUM(Sales[Sales]),
Sales[Date]
)
Previous Year Sales =
CALCULATE(SUM(Sales[Sales]), SAMEPERIODLASTYEAR('DateTable'[Date])
)
CY Sales = CALCULATE(SUM(Sales[Sales]), YEAR(Sales[Date]) = YEAR(TODAY()))
PY Sales = CALCULATE(SUM(Sales[Sales]), YEAR(Sales[Date]) = YEAR(TODAY())-1 )
Previous Month Sales =
CALCULATE(
SUM(Sales[Sales]),
PREVIOUSMONTH('DateTable'[Date])
)
50 Important DAX Functions - Part 2 - Time Intelligence - Sales Analysis