Set Analysis: IF year is 2017 full year sales else only dec month sales

[rammarthi]

Hi,

If Year is 2017, we should have full year sales else we should get only dec month sales for any other year selected.

Thanks in Advance.

[vinieme12]

if( Year = 2017 , SUM({<Year={2017}>} SALES)

                              ,SUM({<Month={12}>} SALES)

               )

[sunny_talwar]

May be this

RangeSum(

Sum({<Year = {$(=Year(Today()))}>}Measure),

Sum({<Year = {$(='<' & Year(Today()))}, Month = {'Dec'}>}Measure)

)