Actually, time intelligence function not works properly on on unfinished date range. It only calculate with existed part instead full range.
For this scenario, I think you had to manually calculate the correspond ranges as filter conditions.(date function)
VAR seleted =
ALLSELECTED ( 'calendar' )
VAR _start =
MINX ( ALLSELECTED ( 'calendar' ), [date] )
VAR _end =
MAXX ( ALLSELECTED ( 'calendar' ), [date] )
SUM ( table[amount] ),
ALL ( 'calendar' ),
>= DATE ( YEAR ( _start ) - 1, MONTH ( _start ), DAY ( _start ) )
<= DATE ( YEAR ( _end ) - 1, MONTH ( _end ), DAY ( _end ) )
Thanks for all your time and help. it seems enough time has passed that the measures can now pick up the neccessary dates and it appears to be fully functional, I appreciate all the help.
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Find out where you can attend!