Solved: syntax

Anonymous · ‎12-17-2018

I have a column that retuen a data with "/"in the middle and in my measure I am creating VAR name/name = "namename" but it seems like I cant use "/" in my code, anyways to get around it without changeing the data?

thanks

v-jiascu-msft · ‎12-17-2018

Hi @Anonymous,

The name/name in "VAR name/name = " is a variable while the "/" in the middle of a column is a value. We can't use special characters in the names of variables. So you can just name a variable like this: VAR namename = "namename".

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-jiascu-msft · ‎12-17-2018

Hi @Anonymous,

The name/name in "VAR name/name = " is a variable while the "/" in the middle of a column is a value. We can't use special characters in the names of variables. So you can just name a variable like this: VAR namename = "namename".

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎12-18-2018

Thanks

Anonymous · ‎12-17-2018

I have a column that retuen a data with "/"in the middle and in my measure I am creating VAR name/name = "namename" but it seems like I cant use "/" in my code, anyways to get around it without changeing the data?

thanks

Greg_Deckler · ‎12-17-2018

Can you post sample data and calculation? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...