Forum Discussion
How to calculate same date range in previous months?
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 , 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()) )
2 Replies
- amitchandak
Super User
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()) )