I want to create a new column which gives me the last day of every week. I already have year_number, month_number, and week_number.
Go to Solution.
Try the following code:
It calculates the max date for each weeknumber and year combination.
Last day of week =
MAX ( 'Calendar'[Date] );
'Calendar'[Week number] = EARLIER ( 'Calendar'[Week number] )
&& 'Calendar'[Year] = EARLIER ( 'Calendar'[Year] )
If you have the ability to use the power query editor to do this use the Date.EndOfWeek() function in a custom column.
Kind regardsJoren VenemaData & Analytics ConsulantIf this reply solved your question be sure to mark this post as the solution to help others find the answer more easily.
View solution in original post
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!