Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 the card and I end up with a count of the field or a sum. I think I need to create a measure that will filter the date table only to 'TODAY' so that I am returned the day of the year for that specific row.
I am not sure how I should structure this DAX formula, fairly new to the program.
Thank you!
Solved! Go to Solution.
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
User | Count |
---|---|
134 | |
70 | |
69 | |
54 | |
52 |
User | Count |
---|---|
205 | |
95 | |
62 | |
61 | |
55 |