You can create a table to extract date value and use it as the category of your visual. Then you can write a measure formula to extract the current date value as a condition to looping table records and get cumulative results.
VAR currDate =
MAX ( 'Date'[Date] )
AVERAGE ( Fact[Price] ),
ALLSELECTED ( Fact),
>= DATE ( YEAR ( currDate ) - 1, MONTH ( currDate ), DAY ( currDate ) )
&& Fact[Date] <= currDate
Regards, Xiaoxin Sheng
Community Support Team _ Xiaoxin If this post helps, please consider accept as solution to help other members find it more quickly.