Forum Discussion
Dynamic Measure based on selected filters/slicers
Community Championid go with option 2, sometimes you just have to start from scratch.
1. create a date table
2. link that date table to your transactional data
this is definitely best practise and make sure your data types are set correctly, this gives you access to a multitude of data functions.
other dax functions you can use for the previous year values
paralellperiod https://msdn.microsoft.com/en-us/library/ee634873.aspx
sameperiodlastyear https://msdn.microsoft.com/en-us/library/ee634972.aspx
Started with a rebuild but everything's the same :/
I can't work out how to get it to look week numbers year-to-year rather dates i.e.; week 08 in 2016/17 doesn't have the same dates as week 08 in 2015/16
PARALLELPERIOD comes close, but will only let me look at years/quarters/months