Add text infront of a colum in dax

[ThomasWeppler]

Hi Power BI community

In my date table I format the date into year, quarter, month and week.
To format the quarter I use this line of dax: 

year_quarter =
FORMAT ( Calender[Date], "q-yy" )

To make sure it isn't to confusing I want to add the letter Q in front of the date so it goes from

3-21 -> Q3-21

Does anyone know how to do this?

[Anonymous]

Hi there- You can try 

With Q =

"Q"&'Table'[Quarter_YY]

This is my first time helping someone, so I hope this works for you. 🙂

[Tahreem24 · Accepted solution]

@ThomasWeppler Try this,

year_quarter = "Q"&FORMAT ( Calender[Date], "q-yy" )