web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Power BI: "To use special characters in a column name..."

(0) ShareShare
ReportReport
Posted on by 3,518

Hi:

I'm trying to create a new column using the following formula:

IF ({dimensionValues[dimension]} IN {dimensionValues[Facility]}, {dimensionValues[display name]})

But, I receive the following error:

To use special characters in a column name, enclose the entire name in brackets []....

Facility is currently another column.  But, I'd like to replace it with a column containing the name of the facility (i.e., the display name).

So, how do I fix this?

John

I have the same question (0)
  • Verified answer
    john.ellis Profile Picture
    3,518 on at

    I figured this out.  I simply needed to pull from a different web service object.

  • Andy Sather Profile Picture
    Microsoft Employee on at

    Thank you for replying back to your post

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,161 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,046 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 932 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans