Forum Discussion
POWER_TESTING
Helper I
Helper IYoY calculation based on Year
Hi Community, can you please help me, i need to calculate YoY based on Year - don't have proper date. please find the attachment
POWER_TESTINGHelper I
Helper II don't have Date table, how would I use dates ??
This Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))
below are my DAX exressions:
MAX_Year_1 = CALCULATE(SUM(Sheet1[Freight]),FILTER(Sheet1, Sheet1[Year]=MAX(Sheet1[Year]) ))
Previous_Year_1 = CALCULATE(SUM(Sheet1[Freight]),FILTER(Sheet1, Sheet1[Year]=MAX(Sheet1[Year])-1))
but these are working for by defauly, if i select year not working.....
ryan_mayu
Super User
Super Useris the previous year value not correct?
maybe you can try this
MAX_Year_1 = CALCULATE(SUM(Sheet1[Freight]),FILTER(Sheet1, Sheet1[Year]=MAX(Sheet1[Year]) ))
Previous_Year_1 = CALCULATE(SUM(Sheet1[Freight]),FILTER(ALL(Sheet1), Sheet1[Year]=MAX(Sheet1[Year])-1))