cancel
Showing results for
Did you mean:
Frequent Visitor

## IF Month equals Now

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Champion

@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")

Lima - Peru
3 REPLIES 3
Community Champion

@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"

Lima - Peru
Community Champion

@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")

Lima - Peru
Frequent Visitor

@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

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors