DAX practice: Calendar Foundations & Date Requirements

Chapter 14 · 3 questions · included in full access

Question 1 · easy
Why every day
Why must a Calendar table contain every day of the year without gaps, even days with no sales?
Solve it in your browser
Question 2 · medium
Weekend orders
Write Weekend Orders: count orders placed on weekends (WeekdayNum >= 6 in Calendar).
Solve it in your browser
Question 3 · hard
Weekend share
Write Weekend Share: divide weekend sales (WeekdayNum >= 6) by [Total Sales].
Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.