Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 .
Solved! Go to Solution.
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
Thanks Ahmed
i got the solution
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
82 | |
74 | |
66 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |