The syntax for 1. is incorrect

[Anonymous]

Calendar Table =

VAR BaseCalendar =

CALENDAR(DATE(2014, 1, 1); DATE(2018,12,31))

RETURN

GENERATE (

BaseCalendar;

VAR BaseDate = [Date]

VAR YearDate = YEAR(BaseDate)

VAR MonthNumber = Month (BaseDate)

VAR YearMonthNumber = YearDate * 12 + MonthNumber -1

VAR QTR = CONCATENATE("Q";RoundUP(MONTH([Date])/3,0))

"Year"; YearDate;

"Month Number"; MonthNumber

"Month"; FORMAT (BaseDate "mm yy");

"QTR"; QTR

)

I keep receiving the folloeing message: The syntax for 1. is incorrect.... I don't know what's wrong with it tough 

[parry2k]

@Anonymous you have missing ; after month number and also in Format function, not sure if it is typo 

[Anonymous]

I Corrected replacing , for ; and also in the FORMAT... It's still not correct T_T

Calendar Table =
VAR BaseCalendar =
CALENDAR(DATE(2014; 1; 1); DATE(2018;12;31))
RETURN
GENERATE (
BaseCalendar;
VAR BaseDate = [Date]
VAR YearDate = YEAR(BaseDate)
VAR MonthNumber = Month (BaseDate)
VAR YearMonthNumber = YearDate * 12 + MonthNumber -1
VAR QTR = CONCATENATE("Q";RoundUP(MONTH([Date])/3,0)
"Year"; YearDate;
"Month Number"; MonthNumber
"Month"; FORMAT (BaseDate, "mm yy");
"QTR"; QTR
)

Something is wrong with the underlined i guess

[v-joesh-msft · Accepted solution]

Hi @Anonymous ,

Maybe you can try the following formula, I think it is simpler:

Calendar Table =
ADDCOLUMNS (
    CALENDAR ( DATE ( 2014, 1, 1 ), DATE ( 2018, 12, 31 ) ),
    "Year", YEAR ( [Date] ),
    "Month Number", MONTH ( [Date] ),
    "Month", FORMAT ( [Date], "mm yy" ),
    "QTR", CONCATENATE ( "Q", ROUNDUP ( MONTH ( [Date] ) / 3, 0 ) )
)

Here is a demo, please try it:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/Ec-W2Zpdvo9Okyjgv4MJ4ssBEopbsjHsbEBu8E5K9Odrjg?e=H59TVp 

Best Regards,

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