DAX Get data for the previous customised time period
Hello, I'm new to DAX and have questions on getting the data for the "Previous Customised time period", I was wondering if anyone can please help? I have the matrix below showing the average and can be sliced by the "Year+Semester" column. What I would like to have is a Measure / Column to show the data for the Previous "Year+Semester". This is the matrix with slicers: This is what I want to achieve, for example, when selecting 2011-2, a measure would show 2011-1 data: Thank you very much!
