This is a dedicated forum for people that have questions about the book Supercharge Power BI. In the event of errors in the book, the error information will be in this forum.
Posts: 2
Joined: Wed Dec 27, 2017 2:11 am


Postby svdv » Wed Dec 27, 2017 2:25 am

In the "Super Charge Power BI" book, why does the Calendar table name always have single quotes around it, while none of the other table names ever do?

E.g. on page 66: 'Calendar'[Calendar Year] = 2003

Funny enough: when hovering over any of the table names under "FIELDS" in PowerBI, they all seem to show those single quotes... (?)

Posts: 1025
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: 'Calendar'

Postby MattAllington » Mon Jan 01, 2018 8:04 am

The word Calendar is a reserved word in Power BI. It is actually a function that can be used to create a calendar table. If you want to use it as a name of a table (as most users do), you must use single quotes to differentiate it from the function.

Visit the following link to read more about my Power BI Training.
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

Return to “Help with the Book "Supercharge Power BI"”

Who is online

Users browsing this forum: No registered users and 2 guests