Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

When need to apply open bracket for table name ?

Hi All

Below need open and close bracket :-

Measure = sumx('TABLE',if([sign] =2, -1*[sales],[sales]))

Below dont need open and close bracket :-

LYTD = CALCULATE(SUM(INVENTORY[YTD]), DATEADD(DATESYTD('Date'[Date]), -1, YEAR))
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi Anonymous ,

     

    We can omit the single quotation marks if the table name does not start with a number, does not contain spaces, and is not a reserved word (like Date or Sum).

     

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

2 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    We can omit the single quotation marks if the table name does not start with a number, does not contain spaces, and is not a reserved word (like Date or Sum).

     

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

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , I think you are talking about Single Quote  '

    This is needed in table name if the table name is a reserved word of Power BI (The word which also used by power bi functions or some other places).

    Example Date, Table , Min, Max etc