Forum Discussion
Filter a table by date using DAX
Hello, How can I filter a table for a date field using DAX? I have a date range to filter. The output would be a second table. Thank you!
Hello Anonymous
Give this a try, you will just need to change the table and column names to match your data.
Filtered Sales = CALCULATETABLE( Sales, DATESBETWEEN ( Sales[Sales Date], DATE(2019,1,15), DATE(2019,2,5) ) )This creates a new table called 'Filtered Sales' that is the Sales table filtered to 1/15/2019 - 2/5/2019
Hello Anonymous
Give this a try, you will just need to change the table and column names to match your data.
Filtered Sales =
CALCULATETABLE(
Sales,
DATESBETWEEN ( Sales[Sales Date], DATE(2019,1,15), DATE(2019,2,5) )
)This creates a new table called 'Filtered Sales' that is the Sales table filtered to 1/15/2019 - 2/5/2019
Thank you so much! Your method worked for me
Hello, is there any option using the filter parameter used in the report? Because i'm trying but the selected date not filter
