topic Re: Using year and week number calculating last date in a week in DAX Commands and Tips

Using year and week number calculating last date in a week

TrulsB — Fri, 03 Apr 2020 05:15:33 GMT

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 ?

Re: Using year and week number calculating last date in a week

Greg_Deckler — Fri, 03 Apr 2020 14:43:09 GMT

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

Re: Using year and week number calculating last date in a week

TrulsB — Mon, 06 Apr 2020 06:36:56 GMT

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.

Re: Using year and week number calculating last date in a week

Greg_Deckler — Mon, 06 Apr 2020 11:18:52 GMT

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])

Re: Using year and week number calculating last date in a week

TrulsB — Wed, 08 Apr 2020 05:29:41 GMT

Perfect ! Thank You !! 🙂

Re: Using year and week number calculating last date in a week

Greg_Deckler — Wed, 08 Apr 2020 11:02:09 GMT

Glad it worked! 🙂