Forum Discussion
Solved
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 da...
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()
BhaveshPatel
Super User
Super UserYou 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()