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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
sraj
Responsive Resident
Responsive Resident

Manage rules DAX fun for INT

Hi,

I am using this in Manage roles to segregate by different queues and I thought this would work [NODE_ID] = "1363", but I am getting this error message.  Data type for NODE ID is whole number.  Can somone please help?

 

sraj_0-1674829793889.png

 

1 ACCEPTED SOLUTION

Hi @sraj 

 

It should be [NODE_ID] = 1363 rather than [NODE_ID] = "1363". Adding double quotes around a number will conver it into Text type. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

4 REPLIES 4
sraj
Responsive Resident
Responsive Resident

May be I am not understanding this but the value is INT 1363  which is a number, can you please specify?  Are you saying it has to be text and not number?

Hi @sraj 

 

It should be [NODE_ID] = 1363 rather than [NODE_ID] = "1363". Adding double quotes around a number will conver it into Text type. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

sraj
Responsive Resident
Responsive Resident

Thank you @v-jingzhang 

HotChilli
Super User
Super User

"1363" is a text string.  It needs a number

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.