Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Same Period Next Year

Hey all,   I am looking for the following:   ID    Products  YearMonth                                               2         1             202002 4         1             202004 5         2  ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    You could use EARLIER() function.

    ProductsNY = CALCULATE(SUM('Table'[Products]),FILTER('Table','Table'[ID]=EARLIER('Table'[ID])&&'Table'[YearMonth]=EARLIER('Table'[YearMonth])+100))

     

    Best Regards,

    Jay

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , if you have date  , then with help from a date table

 

new measure

 

Year behind Sales = CALCULATE(SUM(Table[Products]),dateadd('Date'[Date],-1,Year))

 

else move year period/month in a new table and join back, also have column year and period /month

 

next year = CALCULATE(sum('Table'[products]), FILTER(ALL('Date'),'Date'[Year]=max('Date'[Year])+1 && 'Date'[Month] = Max('Date'[Month])))

ypannnn's avatar
ypannnn
Frequent Visitor
2 years ago

dateadd('Date'[Date],-1,Year) really helps my question! Thank you!!