In the last xxxmonths

[M_SBS_6]

Hi, 

I have a card which has sum(app_val). I have then added in to the filter app_date relative date is in the last 12 months. This shows me data from 02/02/23 to 01/02/24.

Any idea how to show the same relative function but for the period prior i e 02/02/22 to 01/02/23 please? 

[v-weiyan1-msft · Accepted solution]

Hi @M_SBS_6 ,

As far as I know, Relative date doesn't currently support what you want it to do.
As @amustafa replied, you can use slicer's 'between' option.
Or you can try the method below.
According to your description, here is the sample I created:

Please try the following code to create Measure and do the following.

DateDiff = DATEDIFF(SELECTEDVALUE('Table'[Date]), TODAY(), MONTH)

Result is as below.

Thank you, @amustafa , for your helpful and quick response.

Best Regards,
Yulia Yan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amustafa]

Date slicer with relative date settings will not be abe to do what you need. Have you tried using 'between' option? User can then selet the range of the date.