Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I made the following measure:
AVG last 12 Actual months = VAR End_date = DATE ( YEAR(MAX('End of Month Table'[End of month])) , MONTH (MAX('End of Month Table'[End of month]) )-1 , DAY ( MAX( 'End of Month Table'[End of month]))) VAR Begin_date = DATE ( YEAR(MAX('End of Month Table'[End of month])) , MONTH (MAX('End of Month Table'[End of month]) )-13 , DAY ( MAX( 'End of Month Table'[End of month]))) RETURN CALCULATE([SumAmount 1000s] , 'Date','Date'[Date] <= End_date && 'Date'[Date] > Begin_date )
Hi @Anonymous ,
If you want to ignore the oringinal context, you could use ALL() funtion.
Not sure I got it completely
But this formula should be something like this
CALCULATE([SumAmount 1000s] ,all('Date'[Date]),'Date'[Date] <= End_date && 'Date'[Date] > Begin_date )
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |