Need to get sales for last month previous date in DAX

[MeghnaZutshi]

How to write DAX measure to calculate sales for previous day and last month previous day in DAX. Suppose today is April 13 so i would require sales for April 12 and March 12. How to do it? Thanks in advance

[amitchandak · Accepted solution]

@MeghnaZutshi , if you need based on today and there is no date filter

previous day = calculate([net], filter(table, Table[Date] = today()-1) )

previous month day =

var _last = date(year(today()), month(today()) -1, day(today()) )

return

calculate([net], filter(table, Table[Date] = _last ) )

or with the date table ignoring the filter on date table

previous day = calculate([net], filter(all(date), date[Date] = today()-1) )

same way other more such formula 

https://medium.com/chandakamit/cheat-sheet-power-bi-time-intelligence-formulas-using-today-654f26e27...