Using year and week number calculating last date in a week

[TrulsB]

I have a Year and a Week number field in a table, eg Year 2020, and Week 1-53.  (Week 53 is an issue in this case, week 53 is the last days in december when January 1st is in a middle of week. 

How can I calculate the laste date in week, using Year and Week number ?

[Greg_Deckler]

https://community.powerbi.com/t5/Quick-Measures-Gallery/Week-Ending/m-p/389293#M120

[TrulsB]

Hi, thanks I'm close to solution now.  Is far as i can see the "Last week date" is in the Data Table.  Im also using the date table here but do you have any idea how i can calculate or add the last date in week column to this table, based on Year and Week colum?  There is no dates in this table, only year and week.

[Greg_Deckler · Accepted solution]

The basic pattern is here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/td-p/985814

Assuming you have a column in your date table using WEEKNUM:

Last week date column = 
  MAXX(FILTER('Date',YEAR('Date'[Date])=[Year] && 'Date'[Weeknum] = [WeekNo]),'Date'[Date])

[TrulsB]

Perfect ! Thank You !! 🙂

[Greg_Deckler]

Glad it worked! 🙂