Report Showing Last 3 Months worth of Sales

[Boycie92]

Hi,

I’m Wondering if someone can help.

I have a year’s work of sales data. I wasn’t to create a report that will only show the last 3 months’ worth of sales.

I’m aware that I can use a page level filter and change this as appropriate, but I am wondering if there is anyway to write this into my formulas. So that when a new month is entered into the data, that is then added to the report and the first month falls off?

Thanks,

Boycie92

[v-chuncz-msft · Accepted solution]

@Boycie92,

You may take a look at the posts below.

• https://community.powerbi.com/t5/Desktop/How-to-display-total-document-number-for-last-month-data-ba...
• https://community.powerbi.com/t5/Desktop/Display-last-six-calendar-months-minus-this-month/m-p/22826...

[Boycie92]

Hi @v-chuncz-msft

Thanks very much it worked like a treat.

Thanks,

Boycie92