Calculate the last 3 months sales in straight table

[Kohli]

Calculate the last 3 months sales in straight table.

Fields:

Month, Sales

[Anil_Babu_Samineni]

You can use this as measure?

Sum({<Month={">=$(=AddMonths(Max(Month),-3))<=$(=Max(Month))"}>} Sales)

[vishalarote]

Try this,

Sum({<Month={">=$(=Monthstart(Max(Month),-3))<=$(=Max(Month))"}>} Sales)