Forum Discussion

XR043's avatar
XR043
Frequent Visitor
4 years ago
Solved

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!

CALCULATE
DAX
Previous time
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    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.

     

     

     

2 Replies

  • XR043's avatar
    XR043
    Frequent Visitor
    4 years ago

    Thank you very much. That solves my problem!

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

    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.