topic Re: Need to get previous month date by creating a DAX measure. in DAX Commands and Tips

Need to get previous month date by creating a DAX measure.

Anonymous — Mon, 22 May 2023 01:55:26 GMT

PBI_Member_01

I want to see the previous month date against the existing date column in my dataset.

For e.g. If column DOJ shows the date 15/09/22, the measure should show 15/08/22.

We can achieve this output in Calculated Column by writing following DAX

=Dateadd(DOJ,-1,MONTH)

However I am not sure how can we achieve the same result by writing a measure.

Re: Need to get previous month date by creating a DAX measure.

tackytechtom — Mon, 22 May 2023 03:13:49 GMT

Hi Anonymous ,

My tip here is to use a date dimension and precalculate this "samedaypreviousmonth" attribute already in the dimension instead of creating a separate measure.

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

Re: Need to get previous month date by creating a DAX measure.

tackytechtom — Mon, 22 May 2023 03:21:06 GMT

Hi Anonymous ,

If you really wanna use a measure, you can try this one:

DateMeasure = 
VAR _year = YEAR ( SELECTEDVALUE ( TablePivot[Date] ) )
VAR _month = MONTH ( SELECTEDVALUE ( TablePivot[Date] ) )
VAR _day = DAY ( SELECTEDVALUE ( TablePivot[Date] ) )
RETURN
IFERROR ( DATE ( _year, _month - 1, _day), EOMONTH ( DATE ( _year, _month, 1 ), 0 ) )

Does this work?

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

Re: Need to get previous month date by creating a DAX measure.

Anonymous — Mon, 22 May 2023 04:01:09 GMT

Yes, It does. Thanks a lot for quick solution 🙂