Forum Discussion
Date Filter
Good morning people,
I'm trying to create a new table that contains some rows from my main table. I used a DAX but it doesn't work (returns empty table)
New_Table = FILTER(MergeDB, [EndDate] = 30/4/2020)
where MergeDB is my whole data set/table and EndDate is the column that contains the dates in a date format.
I have around 200 rows with different dates and I want to return a table that contains only those
with date 30/4/2020.
SQL code
(select * from MergeDB
where EndDate = '30/4/2020')
Anonymous , Try like
New_Table = FILTER(MergeDB, [EndDate] = date(2020,4,30))
2 Replies
Anonymous , Try like
New_Table = FILTER(MergeDB, [EndDate] = date(2020,4,30))