Amount from today last year until yesterday current year

[Anonymous]

Hi,

if today is 28/06/2024
i want the total amount of measure Sold from 28/06/2023 UNTIL 27/06/2024. 
I have table Time and columns Date, Year, Day, Month
I have measure Sold

How i can reach this result?
Thank you so much

[bhanu_gautam]

@Anonymous , You can achieve this using measures

Total Sold Last Year to Yesterday =
VAR TodayDate = TODAY()
VAR StartDate = DATE(YEAR(TodayDate) - 1, MONTH(TodayDate), DAY(TodayDate))
VAR EndDate = TodayDate - 1
RETURN
CALCULATE(
[Sold],
FILTER(
'Time',
'Time'[Date] >= StartDate && 'Time'[Date] <= EndDate
)
)

[xifeng_L · Accepted solution]

Hi @Anonymous ,

You can try below measure.

MEASURE =
CALCULATE (
    SUM ( Table[Amount] ),
    TREATAS ( CALENDAR ( EDATE ( TODAY (), -12 ), TODAY () - 1 ), Table[Date] )
)

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[Anonymous]

thank you it works!