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

[vishu263]

@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.

[tackytechtom · Accepted solution]

Hi @vishu263 ,

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/

[vishu263]

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

[tackytechtom]

Hi @vishu263 ,

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/