Calculer la somme d'une valeur pour chaque semaine

[Anonymous]

Hi community ,

       Est ce qu'il exciste une formule ou un moyen pour calculer une somme d'une valeur par semaine .

cordialement 

[RedYsl]

Hi,

I have a similar case where I need to display for every product the sales of a specific period : 5 weeks since its first  launch.
It's exactly the solution you gave :

Sales First 5 weeks = 
VAR _WeekStart = [# First Week]
VAR _WeekEnd = [# Last Week]
RETURN CALCULATE( SUM(Fact_Sales[Sales]),
    FILTER( Fact_Sales, Fact_Sales[Week Id] >= _WeekStart && Fact_Sales[Week Id] <= _WeekEnd) 
)

It's working fine, except that when added on a grid, the grand total  is not the sum of every single product's sales.
The filter is also applied to the total..
In other words, it calculates the total sales from the MIN week of ALL products, until the week calculated as MIN + 4 weeks.
Which is not the behavior I want.
For the grand total, I only need the sum of every single row.

Can anybody advise which can be the solution ?

Thanks

[v-lid-msft]

Hi @Anonymous ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

We can try to use the following measure to meet your requirement:

TotalValueOfWeek =
VAR w =
    WEEKNUM ( MIN ( 'Table'[Date] ) )
VAR y =
    YEAR ( MIN ( 'Table'[Date] ) )
RETURN
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            WEEKNUM ( 'Table'[Date] ) = w
                && YEAR ( 'Table'[Date] ) = y
        )
    )

If it doesn't meet your requirement, Please show the exact expected result based on the Tables that we have shared.

Best regards,