cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Rio Frequent Visitor
Frequent Visitor

Display the recent previous month as a default

Hi All,

 

 I have an issue displaying the Total of the previous month. It's working when i filter by month but when I remove all the filter, the default value of the previous month count shows the very first month and not the month prior to the latest month.

 

Total This Month = CALCULATE(SUM(Table[Value]),FILTER(Table,Table[Date]= MAX(Table[Date])))

Total Last Month = CALCULATE([Total This Month], PREVIOUSMONTH(Table[Date]))

 

#newbie #thankyouforthehelp

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Display the recent previous month as a default

@Rio,

 

You may use DATEADD Function.

DATEADD ( Table1[Date], -1, MONTH )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Display the recent previous month as a default

@Rio,

 

You may use DATEADD Function.

DATEADD ( Table1[Date], -1, MONTH )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Rio Frequent Visitor
Frequent Visitor

Re: Display the recent previous month as a default

Thank you so much!! Smiley Happy