Dynamic finds the value assigned to last day of the month

[Anonymous]

Hi, 

From a date column, I would like to calulate a measure which which find the value associated to the last day of the current month. 

Can you assist in this?

Thanks

[collinq · Accepted solution]

Hi @Anonymous ,

The command in Dax for this is the "eomonth" command.  As explained here:

EOMONTH function (DAX) - DAX | Microsoft Learn

But, if you are doing it in M, then it would be these 5 steps:

[trebgatte · Accepted solution]

You can also do this in Power Query if needed. I do this a lot with StartOfMonth to group records.

Define a custom column with Date.EndOfMonth([YourDateTimeColumn])

[collinq]

Hi @Circuscazz ,

The command in Dax for this is the "eomonth" command.  As explained here:

EOMONTH function (DAX) - DAX | Microsoft Learn

[trebgatte · Accepted solution]

You can also do this in Power Query if needed. I do this a lot with StartOfMonth to group records.

Define a custom column with Date.EndOfMonth([YourDateTimeColumn])

[collinq · Accepted solution]

Hi @Anonymous ,

The command in Dax for this is the "eomonth" command.  As explained here:

EOMONTH function (DAX) - DAX | Microsoft Learn

But, if you are doing it in M, then it would be these 5 steps:

[Anonymous]

Sorry DAX measure is needed

[Chewdata · Accepted solution]

Hey!

Do you want a measure or a calculated column?

A measure needs a scalar value, so the EOMONTH() needs to be combined with either MIN() or MAX() to bring it down to a single value. Be aware of the context within the visual. If you have a category that contains multiple dates it will either select  the first date MIN(), or the last date MAX().

The dax for a measure is:

End of month = EOMONTH(MIN(Dates[Date]), 0)

If you want a calculated column, you can use:

End of Month (column) = EOMONTH(Dates[Date], 0)