cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AishwariyaV
Helper IV
Helper IV

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

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 

1 ACCEPTED SOLUTION
asc
Frequent Visitor

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.
 

View solution in original post

1 REPLY 1
asc
Frequent Visitor

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.
 

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors