Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
barwe
Frequent Visitor

When should I use apostrophes around table names

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?

 

1 ACCEPTED SOLUTION
PaulOlding
Solution Sage
Solution Sage

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.

View solution in original post

1 REPLY 1
PaulOlding
Solution Sage
Solution Sage

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.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.