DAX Get data for the previous customised time period

[XR043]

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!

[XR043]

Thank you very much. That solves my problem!

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your dataset looks like, but I tried to create a sample pbix file like below.

Please check the below and the attached file.

All measures are in the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your dataset.