cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
chrisread9907
Frequent Visitor

Today Function in Column

Hi,

 

I have this custom column:

 

= Table.AddColumn(#"Changed Type1", "Is Today", each if [datStart.1] = #date(2016, 11, 3) then "1" else "0" )

 

The result is a 0 or 1 dependandt on if the date is 03/11/16. 

 

How can i make it so that the date is always today like in excel TODAY() ?

1 ACCEPTED SOLUTION

Accepted Solutions
BhaveshPatel Community Champion
Community Champion

Re: Today Function in Column

You should use calculated column in Data view.

 

DAX has the same syntex as Excel for creating today's date.

 

=TODAY()

 

for the Query Editor, Create a new column ans use the below syntax

 

DateTime.LocalNow()

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

2 REPLIES 2
Super User I
Super User I

Re: Today Function in Column

The M query language equivalent is DateTime.LocalNow(). Technically that returns date/time; if you need strictly date-only you have to wrap that in Date.From(). So Date.From(DateTime.LocalNow()).

 

Alternatively you could load the query and add the column in the table editor. That way you can use DAX instead of M, so you can still use TODAY() just like in Excel.


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
BhaveshPatel Community Champion
Community Champion

Re: Today Function in Column

You should use calculated column in Data view.

 

DAX has the same syntex as Excel for creating today's date.

 

=TODAY()

 

for the Query Editor, Create a new column ans use the below syntax

 

DateTime.LocalNow()

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors