Forum Discussion

MFelix's avatar
MFelix
Super User
8 years ago

Hi  Anonymous,

 

You should use something like this:

 

Projected Sum =
CALCULATE (
    TOTALYTD (
        SUM ( Table[Revenue_Amount_c] );
        DATEADD ( Table[Revenue_Date_C]; -2; MONTH )
    )
)
    * 12

 

Regards,

MFelix

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    MFelix This displays when trying to add it to a table with other data:

    • MFelix's avatar
      MFelix
      Super User
      8 years ago
      Do you have a calendar table that relates with revenue date?
      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        MFelix I have a Date table but I don't have a relationship setup with it. Typically when I build formulas I just reference my date table in the formula if needed: