Return "Yes" if last day of the month

[nsaray]

Hi

Really easy but I'm new so need some help

I just need to return a Yes value if a specific date column (Report Date) is the last day of the month

Thanks!

[Anonymous · Accepted solution]

Hi @nsaray ,

You can create a calculated column  or  measure as below to get it:

1. Create calculated column

last day of the month? = IF ( 'Table'[Report Date] = EOMONTH ( 'Table'[Report Date], 0 ), "Yes" )

2. Create a measure as below

Measure for last day of the month? = IF ( MAX ( 'Table'[Report Date] ) = EOMONTH ( MAX ( 'Table'[Report Date] ), 0 ), "Yes" )

Best Regards

[Fowmy]

@nsaray 

Yes,  It will.

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[Fowmy]

@nsaray 

I made a measure, you can repace the variable __Date with your value

Measure Last Date = 

var __date = DATE(2020,12,30) return
IF(
    EOMONTH(__date,0) = __date ,
    TRUE(),
    FALSE()
)

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[nsaray]

Thanks, what if the column name is called "Report Date"

[nsaray]

will this work for Feb and months with 31 days?