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...
ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
3 years ago

Hi,

Try using your date table for your MTD calculation also in your base measure: 
Current MTD $ = TOTALMTD([Total Sales],DATESMTD('Date'[Date]))


I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

  • MC_2023's avatar
    MC_2023
    Regular Visitor
    3 years ago

    Hi, 

     

    I amend the Current MTD $ per your suggestion, but it cannot return any figures...it's weird..

    Anyway, thanks for your kind suggestion.