Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Previous Year To Date

Hi   I've asked the question before and it got solved. I'm not replicating the solutions and I can't get it to work.   I have a sales table with sales recorded from 01/01/2022 to 01/04/2023. I've...
Need Help
Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

Anonymous 

Please try this modified version : 


YTD LY (limited by last date in Data table) =
VAR DataMaxDate =
    CALCULATE ( MAX ( 'Date'[Date] ), ALL ( SalesDashboard ) )
RETURN
    CALCULATE (
        [YTD],
        SAMEPERIODLASTYEAR (datesytd('Date'[Date])), all(dimdate[Date])
)

 

 

 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!

It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠