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: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
889 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
883 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
866 Views
0
amitchandak
Super User
Super User

‎03-25-2022 03:14 AM

@AlanP514 , New column = Today()

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Message 4 of 6
879 Views
0
AlanP514
Post Patron
Post Patron
In response to amitchandak

‎03-25-2022 03:16 AM

Thank you

Message 5 of 6
878 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
884 Views
0
AlanP514
Post Patron
Post Patron
In response to Tahreem24

‎03-25-2022 03:17 AM

Thank you

Message 3 of 6
878 Views

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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

View All