Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |