Counting Days
Part of the Time Intelligence section of Coddy's Power BI journey. Lesson 2 of 17.
COUNTROWS(Dates): calendar days. DISTINCTCOUNT(Sales[Date]): days with a sale.
Daily Revenue = DIVIDE([Revenue], COUNTROWS(Dates))Per day makes long and short months comparable. By store, count the dates in Sales.
Challenge
Write Daily Revenue: Revenue divided by the calendar days in the filter context. It is checked for each month of each year.
All lessons in Time Intelligence
1Dates and Calendars
The Date TableCounting DaysWeekdays and WeekendsFirst and Last DatesRecap - Revenue per Day