Forum Discussion

MC_2023's avatar
MC_2023
Regular Visitor
3 years ago

Cannot return correct MTD sales

Hi,   I'm comparing the MTD sales for the same period of two years, by using below measures: Current MTD $ = TOTALMTD([Total Sales],DATESMTD(Sales[Invoice Date])) SPLY MTD $ = CALCULATE([Curren...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi MC_2023 ,

Please try:

SPLY MTD $ =
CALCULATE (
    [Current MTD $],
    SAMEPERIODLASTYEAR ( 'Date'[Date] ),
    ALLEXCEPT ( 'Sales', 'Sales'[Product Number] )
)

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum