I am trying to create a measure that returns a total for actions that took place in the last 60 days, the current measure is: ActionsInLast60Days = CALCULATE([ActionTotal], FILTER(DateMatrix, DateMatrix[Date] > [Date60DaysInPast]))
This is not working, it is not filtering anything - meaning when I add it to a table as a value and also add the Measure ActionTotal, the values are the same; it's not taking only items in the last 60 days
With some testing I created this measure: ActionsIn2013 = =CALCULATE([ActionTotal], FILTER(DateMatrix, DateMatrix[Year] = 2013))
When I add this as a value to the testing table it works perfectly, only includes items that took place in 2013.
I for the life of can't figure out what I am doing. I am restricted to PP version 1. I have a 'Data tab'e called Date Matrix, it has a relationship to my fact table on the date fields. Any ideas?
This is not working, it is not filtering anything - meaning when I add it to a table as a value and also add the Measure ActionTotal, the values are the same; it's not taking only items in the last 60 days
With some testing I created this measure: ActionsIn2013 = =CALCULATE([ActionTotal], FILTER(DateMatrix, DateMatrix[Year] = 2013))
When I add this as a value to the testing table it works perfectly, only includes items that took place in 2013.
I for the life of can't figure out what I am doing. I am restricted to PP version 1. I have a 'Data tab'e called Date Matrix, it has a relationship to my fact table on the date fields. Any ideas?