MariaDB Error while trying to add a "Q" to quarter column

[Anonymous]

Hello everybody!
I am having some slight problems while creating my report.

I get my data from a mariadb database and for some reason I can't add a "Q" infront of my quarter column values. This is my column right now:

This is how I want it to look:

Everytime I try to change it to this I get this error:

I have also tried chaning the datatype to text but then I get this error:

Does anybody know how to fix this?

If you need more information let me know.

Thank you in advance!
Regards,
David

[Anonymous · Accepted solution]

Okay so really the only way I was able to fix it was to create a new column in the database itself. In this column I formated my data according to my needs and then imported it. I am not saying that there aren't other solutions but this is definetly the most hassle free solution for anybody who is also struggling with a problem similar to mine.

[Anonymous]

Hi @Anonymous ,

Please try the following methods and check if they can solve your problem:

1.Try to Open the Power Query Editor, add a custom column.

2.Enter the following formula.

= "Q" & Text.From(Date.QuarterOfYear([Date]))

3.The result is shown below.

4.Choose Close and apply.

Best Regards,

Wisdom Wu

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