IF Month equals Now

[xpfc]

Hi

Was trying to work out a basic if on if month is now, but I think because I am trying to use a calculated column this is now working, is there a way to do it using a calculated column?

My Calculated column is:

Planned Defleet = Vehicles[for_disposed_date].[Month]&" "&Vehicles[for_disposed_date].[Year]

There I am just trying to look up this month, I have tried the following methods get errors.

CurrentPlannedDefleet = IF(Vehicles[Planned Defleet] = MONTH(now()),"Defleet", "No")

CurrentPlannedDefleet = IF(Vehicles[Planned Defleet] = MONTH(4),"Defleet", "No")

And have also tried:

CurrentPlannedDefleet = IF(Vehicles[Planned Defleet] = FORMAT("April",MONTH(4)),"Defleet", "No")

This one just returns "No" down the whole list when I definatley have some as "April 2017"

Hence my assumption it maybe to do with it being a calculated column.

Any pointers in the right direction would be appreciated.

Thanks

[Vvelarde]

@xpfc

The result of this Column:

Planned Defleet = Vehicles[for_disposed_date].[Month]&" "&Vehicles[for_disposed_date].[Year]

in a date like 01/04/2017 is April 2017

And when you compare (Using IF) : 

CurrentPlannedDefleet = IF(Vehicles[Planned Defleet] = MONTH(now()),"Defleet", "No")

First you have a error because can't compare Text With Integers. 

And Also with the Format April 2017 is equal to 4 Result "No" or April 2017 is equal to April Result "No"

[Vvelarde · Accepted solution]

@xpfc

You can try Using

Column 2 = IF(MONTH(Vehicles[for_disposed_date])=MONTH(Today());"Yes";"No")

This Give you YES is both month are the same but not evalualing the year.

And this evaluate month and Year

Column 2 = if(MONTH([Vehicles[for_disposed_date])=MONTH(TODAY()) && YEAR(Vehicles[for_disposed_date])=YEAR(TODAY());"Yes";"No")

[xpfc]

@Vvelarde

Thanks that works great.

I had also just rewritten it this way which also gets the required result.

CurrentPlannedDefleet = IF(Vehicles[for_disposed_date].[MonthNo] = MONTH(NOW()),"Defleet", "No")

CurrentPlannedDefleet = IF(MONTH(Vehicles[for_disposed_date]) = MONTH(TODAY()),IF(YEAR(Vehicles[for_disposed_date])=YEAR(TODAY()),"Defleet", "No"),"No")

Many Thanks