topic Re: Amount from today last year until yesterday current year in DAX Commands and Tips

Amount from today last year until yesterday current year

Anonymous — Fri, 28 Jun 2024 09:48:26 GMT

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

Re: Amount from today last year until yesterday current year

xifeng_L — Fri, 28 Jun 2024 11:05:35 GMT

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~

Re: Amount from today last year until yesterday current year

bhanu_gautam — Fri, 28 Jun 2024 11:11:32 GMT

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
)
)

Re: Amount from today last year until yesterday current year

Anonymous — Fri, 28 Jun 2024 15:17:01 GMT

thank you it works!