Weekly sum over several years

[andrea_chiappo]

I have looked at other questions and their replies, but I don't get the desired result.

I have two dimensions: a Calendar Table and my Users table.

Following the suggestion in 

https://community.powerbi.com/t5/Desktop/How-to-show-just-the-week-number-in-my-chart-when-I-have-da...,

I added to my Calendar table the week-of-the-year column. Since my this table spans 2018 to 2020,

the column run from 1 to 52 and over again for each consecutive year.

I also added a similar column to my Users table. However, my Users table has dates which run from

November 2018 to February 2020.

When I try using the latter, I simply get some (mysterious) values on an axis running from 1 to 52

However, when I try using the week quantity from the Calendar table (as in other solutions I found),

I get that (some equally mysterious) values are ordered in decreasing order.

I calculate WeeklyUsers measure with the following script

WeeklyUsers = SUMX(

FILTER(

DimUsers,

WEEKNUM(DimUsers[Date],2) = WEEKNUM(LOOKUPVALUE(DimUsers[Date],DimUsers[Index],DimUsers[Index]-1),2) &&

DimUsers[Date] <= LOOKUPVALUE(DimUsers[Date], DimUsers[Index], DimUsers[Index]-1)

),

DimUsers[DailyUsers]

)

What I aim for is a plot showing the number of weekly users (value) vs the corresponding week number (axis),

following the week order in the Users table (eg. 45, 46, 47, 48, 49, 50, 51, 52, 1, 2...)

Any idea anyone how to correct the plot? Thanks 

[amitchandak]

If you want plot weeks across the year you need to have some context of the year into it

Like

Week year = Year & " " & Week

The option of the Sort column will not apply as the values of the week are not unique across the year.