How to get Month Values using set analysis

[varma8998]

Hi All,

By using the below formula I am getting the Max value (September)

(Sum({<Month = {'$(=Date(Max(Date#([Month],'MMMM')),'MMMM'))'}>}[Amount]))

By using the below formula I am getting the Min value (January)

(Sum({<Month = {'$(=Date(Min(Date#([Month],'MMMM')),'MMMM'))'}>}[Amount]))

By using the below formula I am getting the Max -1 value (August)

(Sum({<Month = {'$(=Date(Min(Date#([Month],'MMMM')),'MMMM'))'}>}[Amount]))

I am unable to get the July Value by using set analysis

I am unable to get the June value by using set analysis

and So on...

Below is the Table format:

Month      Place         Amount

January    Canada     1000

February    Mexico     2000

March        USA           3000

April          Australia      4000

May         India             5000

June        India            6000

July       Mexico           7000

August    Mexico          8000

September  USA          9000

Please help me with the correct formula.

[tresesco]

What is your business requirement? Why do you need separate expressions for every months data?

If you need July data you can simply write expression like:

Sum({<Month={'July'}>}Amount)

[raji6763 · Accepted solution]

hi Varma,

your solution here.

please try below expression :

June month-(Sum({<Month = {'$(=Date(Max(Date#([Month],'MMMM'),4),'MMMM'))'}>}[Amount]))

July month- (Sum({<Month = {'$(=Date(Max(Date#([Month],'MMMM'),3),'MMMM'))'}>}[Amount]))

Regards,

raji

[varma8998]

Hi

What ever you did it will help in the constant values.

Every time months will change in those scenario if I do it in dynamic that will be helpful to mu business

[varma8998]

Hi Raji,

Below formula is not working can you please try and let me know again