how to get the data of the latest week in the history

[hemingt]

Hello, 

I have a table to save bugs of each week.

I want to let some charts always display the statistic of the latest week. This latest week may not equal the current actual week.

Do you have some suggestion?

[v-danhe-msft · Accepted solution]

Hi @hemingt ,

Based on my test, you could refer to below steps:

Create below column:

Latest = IF(WEEKNUM('Table1'[Date])=MAXX('Table1',WEEKNUM('Table1'[Date])),"Latest","Not latest")

Set below filter:

You could also download the pbix file to have a view.

Regards,

Daniel He

[hemingt]

Thank you @v-danhe-msft