Forum Discussion

vyslygmhn's avatar
vyslygmhn
New Member
3 years ago

CREATING DYNAMIC FILTER WITH USING MEASURE in FILTER Function

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)
 
Need Help
Show and Tell
Tips and Tricks

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    what is this for, a YoY comparison?

     

    Also note the function STARTOFYEAR.