Forum Discussion
Fixed time range
Hi jayala ,
You just want to show the values for 12 months after the selected date. Right? If so, I think you could create a measure like below:
Selected Date + 365 = CALCULATE ( SUM ( 'Table'[ Sales] ), FILTER ( 'Table', 'Table'[Date] >= MIN ( 'Date'[Date] ) + 365 ) )If you want to show the values which is between selected date and 12 months after that, please try this:
selected date to Selected Date + 365 = CALCULATE ( SUM ( 'Table'[ Sales] ), FILTER ( 'Table', 'Table'[Date] >= MIN ( 'Date'[Date] ) && 'Table'[Date] <= MIN ( 'Date'[Date] ) + 365 ) )Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi amitchandak thank you for your answer but I need something a little bit different. Let's assume that I select a specific Start Date present in my data set, I need to see only data for 12 months after the chosen date.
The relative option seems to be relative to the current date. Am I right?
Thank you again.
Community SupportHi jayala ,
You just want to show the values for 12 months after the selected date. Right? If so, I think you could create a measure like below:
Selected Date + 365 =
CALCULATE (
SUM ( 'Table'[ Sales] ),
FILTER ( 'Table', 'Table'[Date] >= MIN ( 'Date'[Date] ) + 365 )
)
If you want to show the values which is between selected date and 12 months after that, please try this:
selected date to Selected Date + 365 =
CALCULATE (
SUM ( 'Table'[ Sales] ),
FILTER (
'Table',
'Table'[Date] >= MIN ( 'Date'[Date] )
&& 'Table'[Date]
<= MIN ( 'Date'[Date] ) + 365
)
)
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.