Forum Discussion
Solved
Getting a Month Goal to repeat for each Week in a Table
We have: Goals that holds a [Rep]'s Monthly Goal using the first day of the [Month] (e.g. 1/1/2021, 2/1/2021). SalesPerformance that holds the [Rep]'s Daily [Date] Sales Transactions. Calendar tha...
Hi!
Alberto Ferrari created a video last week I think will help you:
https://www.youtube.com/watch?v=7i03UBWk85Y
You have to change the filter context with a measure. Good Luck!
Hi!
Alberto Ferrari created a video last week I think will help you:
https://www.youtube.com/watch?v=7i03UBWk85Y
You have to change the filter context with a measure. Good Luck!
- So while you did your work in a Matrix, it was enough for me to understand the granularity. I was comparing MonthDate to a WeekDate, now from your video... determined I should use MON-YR.SalesGoalforPeriod = sumx(values('Calendar'[MON-YR]),calculate(sum(Sales_Goals_Reps[Goal]),allexcept('Calendar','Calendar'[MON-YR])))Thank you Again.
