topic Calculate sum based on end of month date in DAX Commands and Tips

Calculate sum based on end of month date

RogueTrooper — Fri, 22 Jul 2022 11:11:04 GMT

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 — Fri, 22 Jul 2022 11:14:45 GMT

You forgot to colse MAX before ",0"

RogueTrooper — Fri, 22 Jul 2022 11:22:29 GMT

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

tamerj1 — Fri, 22 Jul 2022 11:38:18 GMT

Like this

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

RogueTrooper — Fri, 22 Jul 2022 20:33:40 GMT

Excellent!

Thanks for taking the time to help resolve this.