Forum Discussion

NewbieJono's avatar
NewbieJono
Icon for Post Partisan rankPost 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 - Hea...
Need Help
  • Alex87's avatar
    Alex87
    2 years ago
    Previous Month Sales = 
CALCULATE(
    [_Headcount Latest],
    DATEADD('Date'[Date], -1, MONTH)
)
Alex87's avatar
Alex87
Icon for Solution Sage rankSolution Sage
2 years ago
Previous Month Sales = 
CALCULATE(
    [_Headcount Latest],
    DATEADD('Date'[Date], -1, MONTH)
)