2 Replies Latest reply on Jan 12, 2017 1:10 AM by Katarina Day

    Calculating measure using 2 dates

    Katarina Day

      Hi,

       

      I have tried to search the forum but didn't find anything that would help me to get what I need. I need to calculate the measure using 2 dates. I have the following columns:

       

      Call Date

      Deposit Date

      Measure (deposit amount)

       

      I need to calculate 2 different measures (sum of deposit amount) based on  first where deposit date is between Call Date and Call Date+1day and second where deposit date is between Call Date and Call Date+7days.

       

      Can someone help please?

       

      thank you