Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Solved! Go to 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])
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.
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])
Perfect ! Thank You !! 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |