Forum Discussion
Get week from Date
Hello, How can i get weeek dates from a date column E.g I have a column Spend and a Date column with continous dates (my spend amount is calculated on daily basis) I need to calculat...
You can use WEEKNUM function in DAX in a calculated column to return the week of the year.
You also need to know if you are using ISO week numbers (Monday through Sunday), in which ALL weeks are complete weeks, or the default week numbering where January 1 is always week 1 and a new week starts on Sunday (e.g. Saturday Jan 1 is week 1 and Sunday Jan 2 is already week 2, which would still be ISO week 52 or 53).