cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

@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

View solution in original post

3 REPLIES 3
Community Champion
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

@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

View solution in original post

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

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

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