Forum Discussion

AspireCraig's avatar
AspireCraig
New Member
7 years ago

Replacing an Integer value with Text using a DAX Formula

Hello everyone, I am struggling with what seems like a simple task. I am new to Power Bi and using a directy query, my vaules are 1,2,3,4,5, etc. in a field called Types and I want to repalce the Id...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi AspireCraig ,

 

I tried working on your example but it works for me without any problem.

your IF formula is also correct. Dont know why you are getting this error. ( May be try to chnage the datatype because you replace)

 

or else you can try this 

In Query editor, you can select the column Types and right click-> replace values.

 

Just make sure your changing the datatype to text. ( since you are replacinmg the numerical values with a text values)

 

 

Also take a look at this post with similar error:

 

https://community.powerbi.com/t5/Desktop/Model-object-names-must-be-non-empty-error-message/td-p/460039

 

https://community.powerbi.com/t5/Desktop/quot-Model-Object-names-must-be-non-empty-quot-error-on-all/td-p/561008

 

Thanks,

Tejaswi

AspireCraig's avatar
AspireCraig
New Member
7 years ago

Hi Tejaswi
Changing the type to text would be too easy, it appears this cannot be done when using a direct query importing will not work as this is live data.  From what I can tell all the records have a value set on them. There are no empty or null values on the 'Types' field.
Anything else to try?