Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
AlanP514
Post Patron
Post Patron

Dynamic Current Date column

‎03-25-2022 03:10 AM

Hello Guys, Could you please help Me to find this requirement?

I want to create a calculated Column, That Column Should Contain the Current Date But it should be dynamic,
(For instance. Today's Date is 3/25/2022, So For tomorrow, my column values should return tomorrow's date.)

Message 1 of 6
1,005 Views
0
1 ACCEPTED SOLUTION
Tahreem24
Super User
Super User

‎03-25-2022 03:14 AM

@AlanP514 , create this:

 Current Date = FORMAT(TODAY(),"MM/DD/YYYY")

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

View solution in original post

Message 2 of 6
999 Views
0
5 REPLIES 5
Anonymous
Not applicable

‎03-25-2022 03:20 AM

you can use TODAY Function EX :- Date_C = Today()
PS:-  it needs to be refreshed daily

Message 6 of 6
982 Views
0
amitchandak
Super User
Super User

‎03-25-2022 03:14 AM

@AlanP514 , New column = Today()

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Message 4 of 6
995 Views
0
AlanP514
Post Patron
Post Patron
In response to amitchandak

‎03-25-2022 03:16 AM

Thank you

Message 5 of 6
994 Views
0
Tahreem24
Super User
Super User

‎03-25-2022 03:14 AM

@AlanP514 , create this:

 Current Date = FORMAT(TODAY(),"MM/DD/YYYY")

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
Message 2 of 6
1,000 Views
0
AlanP514
Post Patron
Post Patron
In response to Tahreem24

‎03-25-2022 03:17 AM

Thank you

Message 3 of 6
994 Views

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All