Power Bi Paginated Report: How to show the Week number for Previous Week?

[Anonymous]

Good Morning,

I have an incredible simple question that frustrating me. I need title of the report to show the week number of the previous week. As the report is showing data for a week behind.

The expression I am currently using is:

=DatePart(DateInterval.WeekOfYear,today())

Which obviously show the current week but no matter how I change the TODAY() it doesn't work

[bradsy · Accepted solution]

he first week of the year could be tricky, this should work:

=IIF(DatePart(DateInterval.WeekOfYear,Today()) - 1 = 0, 52, DatePart(DateInterval.WeekOfYear,Today()) - 1)

[Anonymous]

This worked! Thank you very much