Last day and same day last month

[ShahzadBasra]

I have a data of millions tanx where receive data on daily basis I want to create a dax to calculate same day last month data.

I e current day 27 oct'22 and same day last month 27 Sep'22

[v-easonf-msft · Accepted solution]

Hi, @ShahzadBasra 

You can try formula like:

lastmonth = CALCULATE([Measure],DATEADD('Table'[Date],-1,MONTH))

Best Regards,
Community Support Team _ Eason

[m_alireza]

@ShahzadBasra ,

Are you after this calculated column?

date last month = DATE(Year('Table'[Date]), MONTH('Table'[Date]-1), DAY('Table'[Date]))