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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

how to automatically set today's date

Hi Community, I have a very simple table with only one cell value which is today's date.  Is there a way to make the date automatically update to the current date?  Basically the same as if I were to use the =today() function in excel.  Thanks!

 

 
2 ACCEPTED SOLUTIONS
glissando
Resolver II
Resolver II

Why does it have to be a table?

 

Could it not be a measure? e.g. Today_Date = TODAY()

 

Thanks

View solution in original post

Petazo
Helper I
Helper I

Hello:

I give you two ways below

Today's date to measure, you first create a measure, and then formulate it.

fecha hoy en medida.png

In table, you add a new table and then the formula

fecha hoy en tabla.png

I hope it works for you.

Best regards.

View solution in original post

4 REPLIES 4
Petazo
Helper I
Helper I

Hello:

I give you two ways below

Today's date to measure, you first create a measure, and then formulate it.

fecha hoy en medida.png

In table, you add a new table and then the formula

fecha hoy en tabla.png

I hope it works for you.

Best regards.

Anonymous
Not applicable

thank you!!  both solutions worked great.  

glissando
Resolver II
Resolver II

Why does it have to be a table?

 

Could it not be a measure? e.g. Today_Date = TODAY()

 

Thanks

Anonymous
Not applicable

thanks!  no reason it has to be in a table, i just didn't think about doing a measure.  appreciate your help!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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