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

BrianConnelly's avatar
BrianConnelly
Icon for Resolver III rankResolver III
3 years ago

Did you test my formula, I specifically made it same period?

 

FILTER(ALL(Calendar),YEAR(Calendar[Date]) = todayYear -1

&& Month(Calendar[Date]) <= todayMonth

&& Day(Calendar[Date]) <= todayDay
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Yes, it's pulling up FY, unsure why.

 

 

  • BrianConnelly's avatar
    BrianConnelly
    Icon for Resolver III rankResolver III
    3 years ago

    Can you show the relationships between the table and the date dimension?  It seems you might have a problem there.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago