Forum Discussion
Last Month Data
Let's see if this gets in the right direction:
AnonymousThanks Nick, but how do I get on previous month sum not the running total. Like In OCT I only wnat to see Sep totals.
Anonymouscan I send you my PBIX, it is very simple file with 2 tables
You don't need to have the "Total Sales" measure in the table. Removing that measure, and only having the Previous Month Sales, will show October on the row, but will have September's sales. Though that could lead to some confusion.
Another idea could be to use ParallelPeriod, which shows the grand total of the previous month, regardless if you are at a lower granularity
Sending the PBIX would have saved a lot of time from the start.
Anonymous wrote:Anonymouscan I send you my PBIX, it is very simple file with 2 tables
