Forum Discussion
Solved
Prior Half Year Volume
I need to have a report filtered by year and half year that shows the current half year volume, the current half dollar amount, and the volumes for 2 prior half years. I have done something similar ...
How about
= DATEADD(Date[Date],-6,month)
How about
= DATEADD(Date[Date],-6,month) I tried this
Prior Half Cases = CALCULATE(sum(Data[Cases]),DATEADD('Date'[Date],-6,MONTH))And this is the error I gotOh that error normally is when you dont have a date table. Can you confirm if you are using a date table? if not then try that and use the date from date table in your measure.
If not then this might be an alternate solution:
https://p3adaptive.com/2014/01/defanging-the-contiguous-date-selections-error/
