How to find Year and Month with date format

[naoyixue1]

Hey there,

Is there any way to help to pinpoint Year & Month (format look like: January 2024) For example, I want to flag 'Y", as long as Year and Month = 'January 2024', but it also bring the data with 'Feburary 2024 there'. I know I can use say year & month with number (Year * 100 + Month). But just curious whether there are some ways for me to directly do condition for year and month with date format directly? Thanks!

[HotChilli]

I'm only understanding half of this question.

If you want to test a date use the YEAR and MONTH DAX functions.

If you have a problem with the LOOKUPVALUE returning values in February when they should be in January, show us the rows that are returning February (wrongly) and show us the Time_lookup table.

[ryan_mayu · Accepted solution]

maybe you can try 

if( [year and month]= "January 2024", "Y')

or 

if (format([date],"mmmm")&" "&year([date])="January 2024", "Y')