Forum Discussion

brinky's avatar
brinky
Helper IV
5 years ago
Solved

Exclude current week

Good morning,   I'm trying to get all sales for the last eight weeks. I manged to get the 8 week but would like to exclude the current week Measure 3 = CALCULATE([QTY_Sales], FILTER(SalesDa...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi brinky ,

     

    According to the description, you may try this:

    Measure = 
CALCULATE (
    [QTY_Sales],
    FILTER (
        'SalesData',
        DATEDIFF ( 'SalesData'[Date], TODAY (), WEEK ) < 8
            && DATEDIFF ( 'SalesData'[Date], TODAY (), WEEK ) >= 1
    )
)

     

    If it does not make sense, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

     

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi brinky ,

 

According to the description, you may try this:

Measure = 
CALCULATE (
    [QTY_Sales],
    FILTER (
        'SalesData',
        DATEDIFF ( 'SalesData'[Date], TODAY (), WEEK ) < 8
            && DATEDIFF ( 'SalesData'[Date], TODAY (), WEEK ) >= 1
    )
)

 

If it does not make sense, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

 

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.

brinky's avatar
brinky
Helper IV
5 years ago

Anonymous 

 

Thanks works as required.