Forum Discussion
Calculating Week Start Date from Week Number
Hi there, I have data by week number like this: but I need to add a column that will show me the week end date like this format: The other complication is that the week numbers are ...
Hey jnrezk ,
here I provide a solution that calculates the Start and End-Date for a week:
Solved: Re: Week commencing in DAX - Microsoft Power BI Community
In combination with the following calculations
ISOWEEK = WEEKNUM([date] , 21)
ISO YEAR
=IF([ISOWeek]<5 && [CalendarWeek] > 50;
[Year]+1;
IF([ISOWeek]>50 && [CalendarWeek]<5;
[Year]-1;
[Year]))
in combination with a calendar table, you can use the calendar table as a lookup table to determine the week End Date.
Hopefully, this provides some ideas on how to tackle your challenge.
Regards,
Tom
sorry if im slow and dont follow but its not working - are you saying to create 2 measures first