Range Sum from Max Month

[Daniel99]

Hi All,

I have dataset month from 2/1/2021 - 2/1/2022. 

if i wrote down below:

=sum(if([CPR_TM1_202202.MONTH]>= addmonths(Max(total [CPR_TM1_202202.MONTH]),-2) and [CPR_TM1_202202.Business]='CMB', [CPR_TM1_202202.amount]/1000000000/2))

it will get the sum amount from max date (2/1/2022) to (1/1/2022).

but it's still static. i need to change every month "-2" with another value to get sum current amount.

any idea how to make it dynamic?

Thank you

Regards,

Daniel

[JHuis]

Dear Daniel,

i think you could use: https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Measures/modifiers.h...

But maybe i did not get your question right..