Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am able to calculate my rolling 3 months
Rolling 3 Mo =
CALCULATE (
TBL[VALUE],
DATESINPERIOD (
'Calendar'[Date],
LASTDATE( PREVIOUSMONTH( 'Calendar'[Date]) ),
-3,
MONTH))
However, now I want to be able to look at the previous 3 months less current month... so my current calculation is looking at august, july, and june... now I want a calculation that will look at july, june, and may... any help on this you guys can provide?
Solved! Go to Solution.
Hi,
to get July to August, replace the DATESBETWEEN() function with this
DATESBETWEEN(Calendar[Date],EDATE(MIN(Calendar[Date]),-2),MAX(Calendar[Date])))
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |