Is it month end?

[titanic123]

Hi All, Please help me with the DAX :  If today is month end date then show current month end date, If not show previous month end date.

Is it Today Month End = "Yes" then '2/28/2022' else '1/31/2022'

[tackytechtom · Accepted solution]

Hi @titanic123 ,

How about this:

TomsDateMeasure = 
VAR _endOfCurrentMonth  = EOMONTH ( today(),  0 )
VAR _endOfPreviousMonth = EOMONTH ( today(), -1 )
RETURN
IF ( TODAY() = _endOfCurrentMonth, _endOfCurrentMonth, _endOfPreviousMonth)

Does this solve your issue? 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/