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()
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()