Forum Discussion
Solved
Calculating Previous Year
I have a table that shows average bed_density and Survey_year (2012 - 2020). The table is in the format bed_density | survey_year 2 | 2018 2 .5 | 2019 ...
sp3jossy , create a separate date/year table and use a formula like this. Join this table with your table
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))Refer to my Webinar
Thank you !
sp3jossy , create a separate date/year table and use a formula like this. Join this table with your table
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))
Refer to my Webinar
Thank you !