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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
AlanP514
Helper V
Helper V

Dynamic Current Date column

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.)

1 ACCEPTED SOLUTION
Tahreem24
Super User
Super User

@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

5 REPLIES 5
Anonymous
Not applicable

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

amitchandak
Super User
Super User

@AlanP514 , New column = Today()

Thank you

Tahreem24
Super User
Super User

@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

Thank you

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.