Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
2 years ago
Solved

Previous Month

Hello, I have a DAX formula that brings back the sum for the latest month. How would I return the sum for the previous month?
 
Latest month
_Headcount Latest =
CALCULATE (
    sum('FACT - Headcount'[Volume]),
    LASTDATE ('FACT - Headcount'[Date])
)
 
i have tried this but it does not work: 
_Headcount PM =
CALCULATE (
    [_Headcount Latest],
    PREVIOUSMONTH( ( 'DIM - Date Table'[Date] )
))

 

 

Need Help
  • Alex87's avatar
    Alex87
    2 years ago
    Previous Month Sales = 
CALCULATE(
    [_Headcount Latest],
    DATEADD('Date'[Date], -1, MONTH)
)

1 Reply

  • Alex87's avatar
    Alex87
    Solution Sage
    2 years ago
    Previous Month Sales = 
CALCULATE(
    [_Headcount Latest],
    DATEADD('Date'[Date], -1, MONTH)
)