How to pass month name (String Type)in filters??

[AishwariyaV]

CurMonthSales=calculate(sum(order_details[sales],filter(all(order_details[monthname],order_details[Monthname]=max(order_details[MonthName])))

the above syntax is showing error.

in place of MonthName,if I give monthNum its showing correct result,but im using monthName as slicer 

[asc · Accepted solution]

Try this :

calculate(sum(order_details[sales]),filter(ALL(order_details[monthname]),order_details[monthname]=max(order_details[monthname])))

this will not throw any error but I am afraid that you wont get desired result.

because if you put MAX function for month name, it'll give you max by alphabatically ordering of month which'll be September.

here proper usage is, use MAX with month number.

Hope this will help you.