Need revise different Dimension each time to fresh the data

[eddywong71]

Hi All,

I have Two column  [Join Plan Month] , [Month] 

Dimension:

If( Date#([Join Plan Month],'YYYYMM') >= Date(MonthStart(vMaxMonthYear,-11) ,'YYYYMM')

, [Join Plan Month])

Expression :

SUM({$<Month ={'$(vMaxMonthYear)'}
>}[OPI])

Let say vMaxMonthYear default = 202312 the above expression will show [Join Plan Month] 202301-202312 in a line chart.

However, if i select [Month]= 202305 the  above expression will show [Join Plan Month] 202301-202305 in a line chart.

But if i create a new expression for example below it can fresh again.

If( Date#([Join Plan Month],'YYYYMM') <= Date(MonthStart(vMaxMonthYear,0) ,'YYYYMM')
AND
Date#([Join Plan Month],'YYYYMM') >= Date(MonthStart(vMaxMonthYear,-11) ,'YYYYMM')

, Date([Join Plan Month2],'MMM YY'))

But if i choose [Month] again the past 12 month don't refresh 

[Kushal_Chawda]

@eddywong71  you may need to use set expression in your measure

Assuming your Your Month format is YYYYMM. You may need to use Date# to match format between Join Plan Month & Month

Sum ({<[Join Plan Month]={">=$(=date(addmonths(max(Month),-11),'YYYYMM'))<=$(=max(Month))"}>} Value)

[eddywong71]

Hi Kushal_Chawda,

I want to show Past 12 each Join Plan Month latest OPI

My Dimension is 

If( Date#([Join Plan Month],'YYYYMM') >= Date(MonthStart(vMaxMonthYear,-11) ,'YYYYMM')

, [Join Plan Month])

My expression = 

SUM({$<Month ={'$(vMaxMonthYear)'}
>}[OPI])

Preview

[Kushal_Chawda · Accepted solution]

@eddywong71 

Use Dimension Join Plan Month & use below expressiion

Sum ({<[Join Plan Month]={">=$(=date(addmonths(max(Month),-11),'YYYYMM'))<=$(=max(Month))"}>}[OPI])

[eddywong71]

Thanks for your help !