Forum Discussion

egsiegel's avatar
egsiegel
Frequent Visitor
5 years ago
Solved

CY, PY, PTYD

I have a table that holds data on how many calls where taken in a day. I also have a date table that goes out to 2025 which allows me to show future dates py sales   Date Calls Taken PY Calls...
Need Help
  • egsiegel's avatar
    egsiegel
    5 years ago

    I got it!!!!

    PYTD Calls = CALCULATE ( [PY Calls], FILTER ( Dates, [date] <TODAY() ) )
    seems to work
     
    Thanks for your help
egsiegel's avatar
egsiegel
Frequent Visitor
5 years ago

I got it!!!!

PYTD Calls = CALCULATE ( [PY Calls], FILTER ( Dates, [date] <TODAY() ) )
seems to work
 
Thanks for your help