Current Month calculated column - dax formula troubles

[TimF]

Hi there

i have tried using the following formula to create a calculated column reflecting a "yes" for those rows where [Date Reported] is that same month year.

Post_TempControls_CM =

if (YEAR ('MYOSH Incident Report'[Date Reported ]) = year (today ()) && MONTH ('MYOSH Incident Report'[Date Reported ] = month (today()) ), "Yes", "No" )

Unfortunately it returns "Yes" for rows where [Date Reported] is NOT the current month, in fact three different months. 

Cheers for any assistance.

Tim 

[TimF · Accepted solution]

i may have solved it...

Post_TempControls_CM =

if(YEAR(Today())=YEAR('MYOSH Incident Report'[Date Reported ]) && month(today())= month('MYOSH Incident Report'[Date Reported ]),"Yes","No")

welcome anyone explaining why this one now works over the original one however ?

Cheers

Tim 

[Greg_Deckler]

It's a mystery, seems like you just swapped the order of the values you are comparing. Would need to see the data potentially to try to replicate but that doesn't make a whole lot of sense.