Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
What's wrong with this expression
=sum({<MonthName(Date)={'$(=MonthName(Today())'}>}[Amount)
Regards
Saurabh
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
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