Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am trying to replicate this measure where I take the average of the ratio from the past 3 months to the past 6 months:
Solved! Go to Solution.
@mluanacruz , You need to have measures like
Monthly Avg like
Rolling 3 = calculate(AverageX(Values('Date'[MONTH Year]), DIVIDE(NuM, DEN,0) ),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH))
or
Rolling 3 = CALCULATE( DIVIDE(NuM, DEN,0) ,DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH))
from 3 to 6 month
Rolling 3 = CALCULATE( DIVIDE(NuM, DEN,0) ,DATESINPERIOD('Date'[Date ],eomonth(MAX('Date'[Date ]),-3) ,-3,MONTH))
@mluanacruz , You need to have measures like
Monthly Avg like
Rolling 3 = calculate(AverageX(Values('Date'[MONTH Year]), DIVIDE(NuM, DEN,0) ),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH))
or
Rolling 3 = CALCULATE( DIVIDE(NuM, DEN,0) ,DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH))
from 3 to 6 month
Rolling 3 = CALCULATE( DIVIDE(NuM, DEN,0) ,DATESINPERIOD('Date'[Date ],eomonth(MAX('Date'[Date ]),-3) ,-3,MONTH))
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |