Forum Discussion

EllaJ234's avatar
EllaJ234
Frequent Visitor
3 years ago
Solved

DAX - Between 2 specified dates

Hi all,    I am looking to create a measure that will count the amount of values returned between two dates (1st Jan 2022 - 1st May 2022). However, I can't figure out the correct way. For something...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    You can specify a static date using the DATE function, e.g. DATE(2022,5,24).

    Your syntax for combining filters is wrong, you don't need to specify the table again, so you could use

    FILTER (
    jiraissue,
    jiraissue[CREATED] >= DATE ( 2022, 1, 1 )
        && jiraissue[CREATED] <= DATE ( 2022, 5, 1 )
)

    I think you need and nor or for that condition so I changed it to && not ||

     

johnt75's avatar
johnt75
Super User
3 years ago

You can specify a static date using the DATE function, e.g. DATE(2022,5,24).

Your syntax for combining filters is wrong, you don't need to specify the table again, so you could use

FILTER (
    jiraissue,
    jiraissue[CREATED] >= DATE ( 2022, 1, 1 )
        && jiraissue[CREATED] <= DATE ( 2022, 5, 1 )
)

I think you need and nor or for that condition so I changed it to && not ||