Forum Discussion
Solved
Problem with Calculated Column
Hi guys, I have a table with the sample like this: Date Customer 1/1/2015 A 1/1/2015 B 1/1/2015 C 1/1/2015 D 1/1/2015 E 1/1/2015 F 1/1/2015 G 1/1/2015 H ...
Hi,
Try this formula
=CALCULATE( AVERAGEX(VALUES(Customer[Date]), [Churn Rate]), DATESBETWEEN ( Customer[Date], EDATE(MIN(Customer[Date]),-11),MAX(Customer[Date])))
Hope this helps.
Hi,
Try this formula
=CALCULATE( AVERAGEX(VALUES(Customer[Date]), [Churn Rate]), DATESBETWEEN ( Customer[Date], EDATE(MIN(Customer[Date]),-11),MAX(Customer[Date])))
Hope this helps.
You are welcome.