Forum Discussion

SivaMani's avatar
SivaMani
Resident Rockstar
8 years ago

YTD Calculation

I often face this challenge,

 

I have 2 tables, 1. with dates and 2. without dates(relationship based on another column)

 

How can I calculate YTD of a field which is in the 2nd table?

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi SivaMani,

     

    Can you create a calculated date column in 2nd table via the relationship? Then, you can use this date column to calculate YTD.

     

    Regards,

    Yuliana Gu