Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

The syntax for 1. is incorrect

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

v-joesh-msft
6 years ago
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.

3 Replies

parry2k
Super User
6 years ago
Anonymous you have missing ; after month number and also in Format function, not sure if it is typo
- Anonymous
  Not applicable
  6 years ago
  
  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
    Solution Sage
    6 years ago
    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.

Related content