cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
heddarami
Frequent Visitor

Data type selection after addition/subtraction step doesn't seem to work in Query Editor

Hi everyone, 

 

I'm trying to create a mapping table in the Query Editor where I map values against their closest match. In order to do that, I create a new column in the query editor where I add 1 to the numerical value in another column. My problem is that after I do this addition step and try to change the data type of the new column from integer to "text", the data doesn't look like it actually changes type as it is still cursive as opposed to non-cursive, which is how text type data usually looks.

 

The problem with this is that when I then use the "new" column to merge queries with a column in a different table, it doesn't seem to work as it should - I only get null values after the merge queries step. 

 

Please see the below screenshot for example, the leftmost column and the rightmost column have the same data type (text) but for some reason the data doesn't look the same; in the leftmost column the data is non cursive and in the rightmost colum it is cursive.  This makes me think that for some reason the type transformation I have done doesn't work as it should. 

 

The rightmost column has been added in the query editor by adding 1 to the leftmost column, and I'm wondering if this addition is what makes it impossible to correctly convert to text afterwards. 

 

Does anyone know if I am correct in this assumption? Is there any workaround? Thanks in advance! 

 

 

image.png

1 REPLY 1
v-henryk-mstf
Community Support
Community Support

Hi @heddarami ,

 

Refer to the document links provided below and similar solutions to see if they can help you.

Data types in Power Query | Microsoft Docs

Solved: Power query editor has changed type errors with ne... - Microsoft Power BI Community


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors