Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

MEASURE: LMTD

Hi!   I want to create a measure without using a Datetable. For MTD im using: Month to Date = TOTALMTD(SUM(fLeads[LeadCount]), fLeads[DATE_KEY_LEAD]) For Last Month im using: Last Mont...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous 

    Try this measure for Previous Month MTD.

     

    Prev MTD = CALCULATE(SUM(fLeads[LeadCount]), PREVIOUSMONTH(DATESMTD(fLeads[DATE_KEY_LEAD])))

     

     

     

    Paul Zheng _ Community Support Team
    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
6 years ago
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))

 

This is giving me result for the WHOLE last month and not LMTD as I want to. 

 

Today is 27 July.

I want my LMTD to return result for 27 June.

newbie_pro's avatar
newbie_pro
Regular Visitor
3 years ago

Do you have the solution?
please share if you do..