Menu
CoddyTech
Start learning

DATESYTD Inside CALCULATE

Part of the Time Intelligence section of Coddy's Power BI journey. Lesson 7 of 17.

DATESYTD(Dates[Date]) is the dates of the year so far, used as a CALCULATE filter.

Customers YTD = CALCULATE([Customers], DATESYTD(Dates[Date]))

A customer of January and March counts once in the year: count over the dates, never add months.

CALCULATE takes other filters next to the dates.

challenge icon

Challenge

How many different customers has Lumen had so far this year? Write Customers YTD. It is checked for each month of each year.

bugsy Main icon

Start this challenge with Coddy's AI tutor

What is Bugsy?

All lessons in Time Intelligence

1Dates and Calendars

The Date TableCounting DaysWeekdays and WeekendsFirst and Last DatesRecap - Revenue per Day

2Totals That Grow

Year to DateDATESYTD Inside CALCULATEQuarter to DateRunning TotalRecap - Customers So Far

3Comparing Periods

Same Period Last YearGrowth Year over YearThe Month BeforeMonth over Month GrowthThe Last 7 DaysThe Last 3 MonthsRecap - Year to Date Growth