Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

IF Statement help

Good afternoon, Can someone tell me why this is not working?   IF ( YEAR( 'Casino Project Feb 2020'[Date] ) = YEAR (LASTDATE('Casino Project Feb 2020'[Date])) && MONTH( 'Casino Project Feb 2020...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous 

     

    This is because lastdate returns the current row, you will need to add All(table) as the context:

     

    Column = 
var Lastdate_= CALCULATE(LASTDATE('Casino Project Feb 2020'[Date]),ALL('Casino Project Feb 2020'))
Return 
IF(YEAR( 'Casino Project Feb 2020'[Date] ) = YEAR (Lastdate_)
&& MONTH( 'Casino Project Feb 2020'[Date]) = MONTH (Lastdate_),
"Yes","No")

     

     

    Best regards 

    Paul Zheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

ahmedoye, In the second line, do you mean:

VAR SelectedMonth = MONTH(SELECTEDVALUE(Casino Project Feb 2020'[Date] ))

 

I changed it to Month and now I am getting all "no"'s  so it still isn't doing it correctly....  Do you have any other thoughts?  Thank you so much for looking at this.

ahmedoye's avatar
ahmedoye
Icon for Responsive Resident rankResponsive Resident
6 years ago

Anonymous , I figure you are doing this inside a Calculated Column. Edit your Initial DAX to look like this:

IF (
YEAR( 'Casino Project Feb 2020'[Date] ) = YEAR (LASTDATE(ALL('Casino Project Feb 2020'[Date])))
&& MONTH( 'Casino Project Feb 2020'[Date]) = MONTH (LASTDATE(ALL('Casino Project Feb 2020'[Date]))),
"Yes",
"No"
)
 
If this solution works for you, kindly give a kudo and mark it as the solution to enable others benefit from it.