When should I use apostrophes around table names

barwe — Thu, 04 Nov 2021 12:50:50 GMT

Hi,

I found this measure (In book "The Definitive Guide to DAX" 2nd edidtion. graf 5-16) :

Sales Pct All Products and Customers = VAR CurrentCategorySales = [Sales Amount] VAR AllProductAndCustomersSales = CALCULATE( [Sales Amount], ALL ( 'Product' ), ALL ( Customer ) ) VAR Ratio = DIVIDE ( CurrentCategorySales, AllProductAndCustomersSales ) RETURN Ratio

I don't understand why Product table is around apostrophes and Customer table is not.

Is it an oversight or is it for a purpose?

Re: When should I use apostrophes around table names

PaulOlding — Thu, 04 Nov 2021 15:27:33 GMT

Hi barwe

I suspect it's because Product is also the name of a DAX function, so the apostrophe's are to ensure DAX knows you're talking about a table name rather than the function.

There's no difference in the calculation/result depending on if there is or isn't apostrophes.

topic Re: When should I use apostrophes around table names in DAX Commands and Tips

When should I use apostrophes around table names

Re: When should I use apostrophes around table names