Calculate sum based on end of month date

[RogueTrooper]

Hi.  I'm having an anoying error with my current formula.

The idea is to calulate the value of shipped orders upto and including the current month.

Error reported is "Too few arguments were passed to the EOMONTH function.  The minimum argument count for the function is 2"

Formula:

ALL OS VALUE PERIOD = CALCULATE(SUM(MNSalesOrderLine[OS LCY Value]),

FILTER(MNSalesOrderLine,MNSalesOrderLine[Shipment_Date] <=EOMONTH(MAX(LastRefreshedDate[DateLastRefreshed],0)

Any thoughts?

Regards

Wayne

[tamerj1 · Accepted solution]

Like this

<=EOMONTH(MAX(LastRefreshedDate[DateLastRefreshed]),0)

[RogueTrooper]

Excellent!

Thanks for taking the time to help resolve this.

[tamerj1]

@RogueTrooper 

You forgot to colse MAX before ",0"

[RogueTrooper]

Hi.  Thanks for the quick reponse.

Not sure I quite understand.  Do you mean is should end:

<=EOMONTH(MAX(LastRefreshedDate[DateLastRefreshed]",0")

as the system reports an syntax error on ",0"

Regards

Wayne