Forum Discussion
Week Year Representation
Hi all, I need you help in getting the week year representation in such a way that if every week year should be havinf 7 days from Mon-Sun. For e.g., If we see Dec-2020 dates 28,29,30,31 come...
Anonymous , I think my mistake, we need to do it on week year , try this
Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week Year = year([Week Start date])
min week start of year = minx(filter('Date',[Week Year] =earlier([Week Year])),[Week Start date])
week No = quotient(datediff([min week start of year],[date],day),7)+1Anonymous , Are you looking for ISO week
ISO Week1 = WEEKNUM([Date],21)
Anonymous , Are you looking for ISO week
ISO Week1 = WEEKNUM([Date],21)
Thanks amitchandak , for the swift reply