The syntax for 'month' is incorrect.

[Nolonwabo]

When I add a new measure 

Prev_Month_Orders = CALCULATE([Total_Orders], dateadd(AW_Calender_Lookup[Date], -1, month))

I get an error The syntax for 'month' is incorrect. (DAX(CALCULATE([Total_Orders], dateadd(AW_Calender_Lookup[Date], -1. month)))).

Please help.

My regional setting is English(United States)

[v-alq-msft · Accepted solution]

Hi, @Nolonwabo 

Based on your description, I created data to reproduce your scenario.

Test:

Calendar:

Calendar = CALENDARAUTO()

There is a one-to-one relationship between two tables.

You may create a measure as follows.

Pre_Month_Sales = 
CALCULATE(
    SUM(Test[Sales]),
    DATEADD('Calendar'[Date],-1,MONTH)
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mussaenda]

it has something to do with "," and "."

Try what @Greg_Deckler  is suggesting

[Greg_Deckler]

Are you certain you should not be using ; instead of , Depends on the language setttings. Seems weird, the DAX error is treating the , as a . so I'm guess ; is the way to go.