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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

my expect matrix is below

Date Department Staff type Staff Salary lastmonthsalary
04-01-2019 A R Peter 1
04-01-2019 A C Mary 2
04-01-2019 B R John 3
04-01-2019 B C James 4
04-01-2019 C C Henry 5
05-01-2019 A R Peter 2                             1
05-01-2019 A C Mary 3                             2
05-01-2019 B R John 4                             3
05-01-2019 B C James 5                           4
05-01-2019 C C Henry 6                           5
06-01-2019 A R Peter 3                            2
06-01-2019 A C Mary 4                            3
06-01-2019 B R John 5                             4
06-01-2019 B C James 6                           5
06-01-2019 C C Henry 7                           6

AnkitBI's avatar
AnkitBI
Solution 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
    Solution Sage
    6 years ago

    Thanks Anonymous