Forum Discussion
Is it month end?
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'
Hi Anonymous ,
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/
1 Reply
- tackytechtom
Most Valuable Professional
Hi Anonymous ,
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/