Forum Discussion
Current Day Card
Hello, I need to add a simple card that gives the current day of the year (1 out of 365). I am deriving this column from a calander and everything seems to move smoothly until I add the field to t...
Try this measure. I use a variable for TODAY to cut down on the ()
Day of Year = VAR TodayIs = TODAY() RETURN DATEDIFF( DATE ( YEAR (TodayIs) , 1 , 1) , TodayIs , DAY)
Try this measure. I use a variable for TODAY to cut down on the ()
Day of Year = VAR TodayIs = TODAY() RETURN DATEDIFF( DATE ( YEAR (TodayIs) , 1 , 1) , TodayIs , DAY)
It works! You're awesome