cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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

Accepted Solutions
Highlighted
Resolver I
Resolver I

Re: how to automatically set today's date

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

Highlighted
Helper I
Helper I

Re: How to automatically set today's date

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
Highlighted
Resolver I
Resolver I

Re: how to automatically set today's date

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

Highlighted
Helper I
Helper I

Re: How to automatically set today's date

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

Highlighted
Helper I
Helper I

Re: how to automatically set today's date

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

Highlighted
Helper I
Helper I

Re: How to automatically set today's date

thank you!!  both solutions worked great.  

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors