Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

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 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!

Day of Year.JPG

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

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)

day of year.jpg

View solution in original post

2 REPLIES 2
jdbuchanan71
Super User
Super User

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)

day of year.jpg

Anonymous
Not applicable

It works! You're awesome

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.