topic Re: DAX Get data for the previous customised time period in DAX Commands and Tips

DAX Get data for the previous customised time period

XR043 — Mon, 22 Aug 2022 10:59:41 GMT

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!

Re: DAX Get data for the previous customised time period

Jihwan_Kim — Mon, 22 Aug 2022 11:30:11 GMT

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.

Re: DAX Get data for the previous customised time period

XR043 — Mon, 22 Aug 2022 22:39:46 GMT

Thank you very much. That solves my problem!