Forum Discussion

ApurvaKhatri's avatar
ApurvaKhatri
Helper 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
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi ApurvaKhatri,

 

You said the dates are continuous. I am not going to create a new date table. 

1. Create a new Calculated Column "WeekNum".

WeekNum = WEEKNUM([Date] + 1,1)

2. Two measures.

StartOfWeek = min('Table1'[Date])
EndOfWeek = max('Table1'[Date])

3. Create a report. 

[Year]  [Weeknum]  [StartOfWeek]  [EndOfWeek] [Spend] (sum)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale