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

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

Anonymous , try using this measure for a try:

VAR SelectedYear = YEAR(SELECTEDVALUE(Casino Project Feb 2020'[Date] ))
VAR SelectedMonth = YEAR(SELECTEDVALUE(Casino Project Feb 2020'[Date] ))
VAR LatestDate = MAX('Casino Project Feb 2020'[Date])
VAR LatestYear = YEAR(LatestDate)
VAR LatestMonth = MONTH(LatestDate)

RETURN IF(SelectedYear = LatestYear && SelectedMonth = LatestMonth, "Yes", "No")

if this Solution works for you, kindly kudo and mark as solution to enable others benefit from it.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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....