Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

previousmonth does not work

Hi, I have two data set. first one is data and second is date table Data: Date Department Staff Staff type Salary 04-01-2019 A Peter R 1 04-01-2019 A Mary C 2 04-01-2019 B John R 3 04-01...
Need Help
  • AnkitBI's avatar
    AnkitBI
    6 years ago
    Try Below
    lastmonth = CALCULATE(SUM(Data[Salary]),PREVIOUSMONTH(Data[Date]))

    Thanks
    Ankit Jain

    Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

AnkitBI's avatar
AnkitBI
Icon for Solution Sage rankSolution Sage
6 years ago
Try Below
lastmonth = CALCULATE(SUM(Data[Salary]),PREVIOUSMONTH(Data[Date]))

Thanks
Ankit Jain

Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

AnkitBI's avatar
AnkitBI
Icon for Solution Sage rankSolution Sage
6 years ago

Thanks Anonymous