CREATING DYNAMIC FILTER WITH USING MEASURE in FILTER Function

[vyslygmhn]

Hello everyone,

I created a calculation that shows which day we are in the year. You can see it below.

day_of_year = DATEDIFF(DATE(YEAR(TODAY()),1,1),TODAY(),DAY)+1

I want to write a calculation that will check the equality of this calculation and the same calculation in the date table. Can anyone help? Maybe sth like these ?

test = IF(FILTER('Calendar',VALUES('Calendar'[DayofYear])<[day_of_year]),1,0)

[lbendlin]

what is this for, a YoY comparison?

Also note the function STARTOFYEAR.