Calculate sum by weeks in Power BI

[Analitika]

Hello,

How to calculate let say sales by weeks? Now I have sum per all period. Starting weekday is Sunday.

[sajjadansari]

WeekNumber = CONCATENATE("Week ",WEEKNUM(Tablename[Date],2)-WEEKNUM(EOMONTH(Tablename[Date],-1)+1)+1)

[v-eqin-msft · Accepted solution]

Hi @Analitika ,

Let's assume there is a table with Date column(from 2021/1/1/ to 2022/5/20) and Value column.

If you want to calculate the sum value of each week  and the starting weekday is Sunday, please firstly create a Week column using WEEKNUM()

Week = WEEKNUM([Date],1)   // the second parameter is set as 1 which means the starting weekday is Sunday.

Then create a sum column or measure:

Sum by week column = CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Week] ,'Table'[Date].[Year]))

Sum by week measure = CALCULATE(SUM('Table'[Value]),FILTER('Table',YEAR([Date])=YEAR(MAX('Table'[Date])) && [Week]=MAX('Table'[Week])))

Output:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.