monthname in set analysis

Thu, 18 Aug 2016 06:12:18 GMT

Hi,

What's wrong with this expression

=sum({<MonthName(Date)={'$(=MonthName(Today())'}>}[Amount)

Regards

Saurabh

Re: monthname in set analysis

kaushiknsolanki — Thu, 18 Aug 2016 06:14:56 GMT

Hi,

It is not possible to use the Function like you did.

Instead you should create a field MonthName(Date) in Script like below.

Load *,MonthName(Date) as MonthYear From XYZ;

And then use below expresssion.

=sum({<MonthYear={'$(=MonthName(Today())'}>}[Amount)

Regards,

Kaushik Solanki