Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter a table by date using DAX - again

Greetings all,   Sorry for being stupid, I'm still very new to DAX. Back in 2019 in this community, a question was asked about filtering dates. I think I'm trying to do the same thing, but I'm fail...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous the above code is for table not meaure

     

    so either create a table

     

    to create a measure like

     

    countorws(CALCULATETABLE(
    'date table',
    DATESBETWEEN ( 'date table'[date], DATE(2021,12,26), TODAY())
    ))

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous the above code is for table not meaure

 

so either create a table

 

to create a measure like

 

countorws(CALCULATETABLE(
'date table',
DATESBETWEEN ( 'date table'[date], DATE(2021,12,26), TODAY())
))