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() ?
Go to Solution.
You should use calculated column in Data view.
DAX has the same syntex as Excel for creating today's date.
for the Query Editor, Create a new column ans use the below syntax
View solution in original post
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.
Proud to be a Super User!
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!