Date measures

Hi, Anonymous 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may create measures as below.

Today Qty = 
CALCULATE(
    SUM('Table'[Quantity]),
    FILTER(
        ALLEXCEPT('Table','Table'[CustomerID]),
        [Date]=TODAY()
    )
)

Yesterday Qty = 
CALCULATE(
    SUM('Table'[Quantity]),
    FILTER(
        ALLEXCEPT('Table','Table'[CustomerID]),
        [Date]=TODAY()-1
    )
)

WTD Qty = 
CALCULATE(
    SUM('Table'[Quantity]),
    FILTER(
        ALLEXCEPT('Table','Table'[CustomerID]),
        YEAR([Date])*100+WEEKNUM([Date])=YEAR(TODAY())*100+WEEKNUM(TODAY())&&
        [Date]<=TODAY()
    )
)

MTD Qty = 
CALCULATE(
    SUM('Table'[Quantity]),
    FILTER(
        ALLEXCEPT('Table','Table'[CustomerID]),
        YEAR([Date])*100+MONTH([Date])=YEAR(TODAY())*100+Month(TODAY())&&
        [Date]<=TODAY()
    )
)

YTD Qty = 
CALCULATE(
    SUM('Table'[Quantity]),
    FILTER(
        ALLEXCEPT('Table','Table'[CustomerID]),
        YEAR([Date])=YEAR(TODAY())&&
        [Date]<=TODAY()
    )
)

Result:

You may remove the calculated columns. They are created just for clear distinction. Today is 3/3/2021.

Best Regards

Allan

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