How to include week start and week end in my calender

[cinlod]

Hello,

Please, kindly assist me with the formula to add two columns for week start and week end in my calender table. I want to create a measure that calculates the average of sales every week.

Many thanks,

[Abduvali · Accepted solution]

Hi  @cinlod,

Try the following:

• Create column: WeekNum = WEEKNUM(Sheet1[Date],2)
• Create Measure: Average Sales = AVERAGE(Sheet1[Sales])

Average Sales for Week 2

Hope this helps.

Regards

Abduvali

[cinlod]

Thanks a lot

problem solved

Many Thanks.

[MFelix]

Hi @cinlod

You can add the weeknum on your calendar table:

WEEKNUM = Weeknum (Calendar[Date])

Then you can calculate your average based on your weeknum.

Regards,

MFelix