Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Previous Year To Date

Hi,   Apologies as I know this has been asked and answered numerous times before.   I'm trying to get the sales for LY 01/01/2022 to todays date but unsure on how to go about it.   I tried to u...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Anonymous 

    you need some code to reflect YTD, try like:

    CALCULATE(
        SUM(Transactions[Sales]),
        DATESYTD(SAMEPERIODLASTYEAR(Calendar[Date]))
    )

ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
3 years ago

Hi,

Here is one way to do this:

LY_to_today =
var LY_Start = DATE(YEAR(TODAY())-1,1,1) return

CALCULATE(SUM('Table (28)'[value]), DATESBETWEEN('Calendar'[Date],LY_Start,TODAY()))

end result:



I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/