Forum Discussion

george31's avatar
george31
Regular Visitor
6 years ago
Solved

Problems calculating week to date from selected date

I am trying to calculate the WTD (week to date starting on Mondays) and MTD / YTD figures on a table where person can select the date to base this on. It would seem it should be fairly easy as we wa...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    george31 see attached, there are many tables, for you, just look at customer service  and calendar table  and measures in Customer Service table

     

    Would appreciate Kudos 🙂 if my solution helped.

george31's avatar
george31
Regular Visitor
6 years ago

Correction: formulae should have been <= [Selected Date]

 

Have also tried 

CALCULATE(SUM(TRC[Answered]), FILTER(TRC,TRC[dateYearWeek] = [Selected YearWeek]))
 
and 
CALCULATE(SUM(TRC[Answered]), FILTER(ALL('Calendar'),'Calendar'[calYearWeek] = VALUES('Calendar'[calYearWeek]) && 'Calendar'[Date] <= MAX('Calendar'[Date])))
 
but none seem to give correct result and always seem to return the SUM(Answered) for selected day.
  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    george31 so you want Week To Date total by each queue and week starting Monday, correct?

    • parry2k's avatar
      parry2k
      Super User
      6 years ago

      george31 see attached, there are many tables, for you, just look at customer service  and calendar table  and measures in Customer Service table

       

      Would appreciate Kudos 🙂 if my solution helped.

    • george31's avatar
      george31
      Regular Visitor
      6 years ago

      Thanks very much parry2k .

      Very simple solution.

      Another thing I had to do is use the Calendar[Date] in my table/matrix rather than I had used the TRC[Date] which seem to show extra info but no matter.

      Appreciate your quick precise help!!