Concatenated formula in excel - reformated to date when upload to Power Bi

[wenzsa]

I have a concatenated column to bring together the Month name and year., but when I import the data to power Bi it is changing the format of my concatenated column to the date. I changed the format in Power Bi to text and it still shows the date. I want it to show the concatenated Month and year.  See the screenshot, any help? Please and thank you!

[themistoklis · Accepted solution]

@wenzsa 

You can load the first 2 columns and then create the concatenated field in Power Query

Click Add Column -->Custom Column and on the pop window add this formula [Month Name] & " " & [Year]

[v-angzheng-msft]

 Hi, @wenzsa 

Because the engine implicitly converts text to numbers as necessary, an easier way to do this is to remove the default step(Changed Type) in the Query Editor

Sample:

Result:

Check data type:

Is this the result you want? Hope this is useful to you

Please feel free to let me know If you have further questions

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

[Ashish_Mathur · Accepted solution]

Hi,

Write this calculated column formula

=[Month]&" "&[Year]

Hope this helps.

[themistoklis · Accepted solution]

@wenzsa 

You can load the first 2 columns and then create the concatenated field in Power Query

Click Add Column -->Custom Column and on the pop window add this formula [Month Name] & " " & [Year]