Show last month data in report

[sunil222]

Hi,

How to show the last month data , Now we are in current month january 2024  , i need the last month i.e December 2023 data 

Please help me on this 

I used this formulae but the year is taking as current .

Last Month = CALCULATE(SUM('SalesTeamPerformance'[Actual]),YEAR('SalesTeamPerformance'[Month year])=YEAR(TODAY()) && MONTH('SalesTeamPerformance'[Month year])=MONTH(TODAY())-1)

[Ahmedx · Accepted solution]

pls try htis

[Dangar332]

hi, @sunil222 

try below

my first answer was wrong

now go with below

pre year pre month = 
var a = EOMONTH(MIN('Data Date'[Date]),-1)
var b = EOMONTH(MIN('Data Date'[Date]),-2)+1
var c =  CALCULATE([salesamountm],'Data Date'[Date]<=a,'Data Date'[Date]>=b)
return
c

[Ahmedx · Accepted solution]

pls try htis

[sunil222 · Accepted solution]

Thanks Ahmed

i got the solution

[Dangar332]

hi, @sunil222 

try below measure 

pre year pre month = 
var a = EOMONTH(MIN('Data Date'[Date]),-13)
var b = EOMONTH(MIN('Data Date'[Date]),-14)+1
var c =  CALCULATE([salesamountm],'Data Date'[Date]<=a,'Data Date'[Date]>=b)
return
c