Forum Discussion

henryvu93's avatar
henryvu93
Icon for Helper I rankHelper I
8 years ago
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 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

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.

  • henryvu93's avatar
    henryvu93
    Icon for Helper I rankHelper I
    8 years ago

    Hi Ashish_Mathur,

     

    The formula worked perfectly! Thanks a lot for your help!

     

    Regards,

    Henry

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    You are welcome.