Set Analysis

[kevbrown]

Hi,

I'm looking to create some set analysis but it's not working

So what I have is Year, Month and Sales

I'm looking to sum sales where the year is always 2016 and the Month remains the same no matter what selection is made on it. I have -

=Sum({<[Year]={'2016'},{1}[Month]>}[Sales])

But it's stating I have an error

[sunny_talwar · Accepted solution]

Try this (you don't need {1} next to Month)

=Sum({<[Year] = {'2016'}, [Month]>} [Sales])

[kevbrown]

Easy as that! thanks

[dsharmaqv]

try this

=Sum({<[Year] = {'2016'}, [Month]=>} [Sales])