Forum Discussion

ApurvaKhatri's avatar
ApurvaKhatri
Icon for Helper III rankHelper III
8 years ago

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...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

You can use WEEKNUM function in DAX in a calculated column to return the week of the year.

MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
8 years ago

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).