Task from Ritu Malhotra, BI Lead, Trivedi Retail
The sales model is built, relationships are in place, Calendar is marked as the date table. I need four measures written before the dashboard review tomorrow. Write real DAX, exactly as you would type it into Power BI Desktop. I will review them like a pull request: no execution engine here, just an experienced pair of eyes, so name your measures properly and mind your filter context.
Sales(Date, ProductKey, StoreKey, Qty, UnitPrice, Discount) -- fact table
Products(ProductKey, ProductName, Category) -- 1 to many with Sales
Stores(StoreKey, StoreName, City) -- 1 to many with Sales
Calendar(Date, Year, Month, MonthNo) -- marked as date table, related to Sales[Date]
Products(ProductKey, ProductName, Category) -- 1 to many with Sales
Stores(StoreKey, StoreName, City) -- 1 to many with Sales
Calendar(Date, Year, Month, MonthNo) -- marked as date table, related to Sales[Date]
1. [Total Sales]: net revenue, Qty times UnitPrice, minus the Discount amount per row.
2. [Sales LY]: the same net revenue for the same period last year.
3. [Electronics % of Total]: Electronics revenue as a share of ALL categories, ignoring any category filter on the visual.
4. [Sales YTD]: year to date running total of net revenue.
Graded by AI like a senior code review: honest, specific, no scores invented by a machine that cannot run DAX. Attempt all four for the best feedback.