This simple dashboard provides information about a company’s auto sales. The database is in csv format and was downloaded from Kaggle.com. All performance indicators were created with the DAX language.
Dax Code
Budget Variance% = DIVIDE([CY Sales] - [Budgeted Sales], [Budgeted Sales], BLANK())
---------
Budgeted Sales =
VAR CY = MAX('Date dim'[Year])
RETURN
CALCULATE(SUM(Budget[Budgeted Amt]), 'Date dim'[Year] = CY)
---------
CY Sales =
VAR CY = MAX('Date dim'[Year])
RETURN
CALCULATE(
SUM(Sales[Sale Amount]),
'Date dim'[Year] = CY
)
-------
PY Sales = CALCULATE([CY Sales], SAMEPERIODLASTYEAR('Date dim'[Date]))
-------
YOY Sales Groth% = DIVIDE([CY Sales] - [PY Sales], [PY Sales], BLANK())
