Filter reports last month, during the week.

[giangnguyen]

Dear All,

Currently I have the date column data as shown in the yellow image below, I need to filter the data for the last month, last week.

[v-diye-msft · Accepted solution]

Hi @,

1. You can use the new filter experience as below:

More info please refer : https://docs.microsoft.com/en-us/power-bi/power-bi-report-filter-preview

2. Alternatively, you can use below measures:

Values of last 7 days = CALCULATE(MAX(Table1[Value]),FILTER(Table1,Table1[Date]>=[today]-7))
Values of last 30 days = CALCULATE(MAX(Table1[Value]),FILTER(Table1,Table1[Date]>=[today]-30))

Best regards,

Dina Ye

[v-diye-msft]

Hi @giangnguyen 

If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

Best regards,

Dina Ye

[giangnguyen]

@v-diye-msft 

I have applied but not as expected, the data does not appear as expected, or I made a mistake somewhere. Currently the image below shows the total data and I want to filter as required, maybe you just add the action.