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
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
BhaveshPatel
Community Champion
Community Champion

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
BhaveshPatel
Community Champion
Community Champion

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.
KHorseman
Community Champion
Community Champion

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? Mark my post as a solution!

Proud to be a Super User!




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.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.