How to calculate same date range in previous months?

[Anonymous]

Hi,

I have a daily table of dates and sales columns. I'm showing the monthly total sales, but I want to add one more column to calculate the same range as in the past months. So if there is data from March 1-24, I want to show February as both the same total and February 1-24. The sample table I want is as follows. I tried many formulas and ranges but could not get the result.

Thanks

[Anonymous]

thanks, solved 😎

[amitchandak · Accepted solution]

@Anonymous , Assume you have date date that is used do disply data month wise

calculate(Sum(Table[Value]), filter('Date', day('Date'[Date]) <= day(today()) )  )

or

calculate(Sum(Table[Value]),,DATESMTD('Date'[Date]), filter('Date', day('Date'[Date]) <= day(today()) ) )

or

calculate(Sum(Table[Value]),,DATESMTD('Date'[Date]), day('Date'[Date]) <= day(today()) )