'Calendar'

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.
svdv
Posts: 2
Joined: Wed Dec 27, 2017 2:11 am

'Calendar'

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... (?)

MattAllington
Posts: 931
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.
Matt Allington is Self Service BI Consultant, Trainer and Author of the book "Supercharge Power BI".
https://exceleratorbi.com.au/power-bi-online-training/


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

Who is online

Users browsing this forum: No registered users and 1 guest

cron