Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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!
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

How can I create a measure to get the values for one specific date, 

 

I created a variable for the date, but the calculate(measure, filter(date=variable date)) returns a blank result