Year is not recognized in DATEADD (and other formulas)

[RobindeKater]

Hi all,

Can anybody tell me where this error is coming from?

Test = DATEADD(DimPeriode[Datum], 1, year)

Gives this error:

The syntax of 'year' is incorrect.

I've tried everything ; in stead of , jaar (that's dutch) in stead of year, years in stead of year, month in stead of year etc. etc. I'm using version Version: 2.70.5494.761 64-bit (June 2019), regional settings are 'English (Nederlands)'.

Hope to hear from you,

Robin

P.S. same error here:

[v-frfei-msft]

Hi @RobindeKater ,

We can update your formula like this. Please have a try 🙂

Verkopen12 = calculate (
[Anatal TST],FILTER(ALL(DimPeriode),
AND(DimPeriode[Datum]<= MAX(DimPeriode[Datum]),
DATE(YEAR(DimPeriode[Datum])+1,MONTH(DimPeriode[Datum]),DAY(DimPeriode[Datum]))>MAX(DimPeriode[Datum])
)
)
)

[RobindeKater]

Hi Frank,

It must be something locally on my computer. Now an error appairs at the month-part of the date-formula.

[v-frfei-msft]

Hi @RobindeKater ,

Did you use Import or direct query? Is that possible to share your sample data to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[RobindeKater]

Hi @v-frfei-msft  Frank,

Did you find anything to help me?

Robin

[RobindeKater · Accepted solution]

I've found the solution to the problem. Although it is nowhere to be mentioned, you should have a leading space before the comma.

Test = date(2012,7,8) gives an error

Test = date(2012 ,7 ,8) doesn't.

To be honest I think this is a bug. It is not mentioned in the official microsoft tutorial:

[RobindeKater]

Hi Frank,

This is the link to the file:

https://1drv.ms/u/s!AvIL2Vb5RRlvm1udUF1MaqXtJHCV?e=2B6WWJ

Thanks!

Robin